I have a wired problem here, I am getting the following error message when the job is executed by sql agent.
"Executed as user: domain\user. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:15:01 PM Error: 2010-09-16
17:15:58.67 Code: 0xC020200E Source: DFT FFD Report Output  Description: Cannot open the datafile "\\serverpath\MyList.csv".
End Error Error: 2010-09-16 17:15:58.68 Code: 0xC004701A Source: DFT My_List DTS.Pipeline Description: component "FFD Report Output" (12331) failed the pre-execute phase and returned
error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:15:01 PM Finished: 5:15:59 PM Elapsed: 58.391 seconds. Process Exit Code 1. The step failed."
This was working fine from years, but has started giving this error from past 3 days. When I run manually this SSIS package it works fine without any errors. Nothing has been changed. Please help.
Thanks in advance.
View Complete Post