Hi All,
I have Create a job as ETL_Load which calls SSIS Package. Outcome of this Package is error. The same error return to Job steps from SSIS package. But Eventhougth the Job step is having an error, job getting succeed.
In Job step Advanced tab, on success action and on failure action set correctly. The below are the JobStep history. Can you please suggest me what could be the problem here
Executed as user: ENTERPRISE\kumaba02. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:05:16 AM Error: 2012-04-02
09:39:29.26 Code: 0xC002F210 Source: Usp_OR_SQL_Xcd_Dscr_v Execute SQL Task Description: Executing the query "Exec Ogrds_ETL.Usp_OR_SQL_Xcd_Dscr_v " failed with the following error:
"Could not find stored procedure 'Ogrds_ETL.Usp_OR_SQL_Xcd_Dscr_v'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec:
The package execution returned DTSER_SUCCESS (0). Started: 6:05:16 AM Finished: 9:39:29 AM Elapsed: 12853.3 seconds. The package executed successfully. The step succeeded.
The job succeeded. The Job was invoked by User ENTERPRISE\kumaba02. The last step to run was step 1 (FinalPkg_New).
Thanks in Advance!
Thanks & Regards, Anil
