SSIS PACKAGE WORKING FINE RUN MANUALLY BUT SCHEDULED THROUGH JOB ITS GETTING FAILED

  • Executed as user: REDMOND\buitsql. ...on 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:45:35 AM Warning: 2008-07-31 06:45:36.08 Code: 0x80012017 Source: OSB_Planning_Forecast_ReportingModelLoad Description: The package path referenced an object that cannot be found: "\Package.Variables[User::glo_msndwdb].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning Warning: 2008-07-31 06:45:36.08 Code: 0x80012017 Source: OSB_Planning_Forecast_ReportingModelLoad Description: The package path referenced an object that cannot be found: "\Package.Variables[User::glo_kpidb].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning Warning: 2008-07-31 06:45:36.08 Code: 0x80012017 Source: OSB_Planning_Forecast_ReportingModelLoad Des... The package execution fa... The step failed.

  • This is a very common problem is SSIS..So, what you are trying do if you can explain, there will be a better solution....

    I am guessing, defining your variables scope is the problem....Verify whether you have defined variable at the container level and try to use/read it at the package level...

    -VG

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply