I have created an SSIS package that uses a File Systen Task (copy) that copies a file from 1 folder to another. The package runs fine when I run it from my local computer but when I import the package into our SQL Server and Create a Job to run the Package, the package fails and I see the following error in the log:
Started: 3:20:01 PM Error: 2013-03-27 15:20:01.70 Code: 0xC002F304 Source: copy template File System Task Description: An error occurred with the following error message: "Could not find a part of the path 'P:\IT\PROVIDERS\PROVIDERS AUDIT\File Template\QnxtProviderAuditList_yyyymmdd.xlsx'." End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:20:01 PM Finished: 3:20:01 PM Elapsed: 0.452 seconds. The package execution failed. The step failed.
The file path in the error is the file that needs to be copied (
I can copy the file path directly from the error and go to it (via windows explorer) on the physical SQL Server machine so I do not understand why the package is saying it could not find the Path.
Does anyone have any idea why this package would run fine on my local machine but fails with the above error when run from the SQL Server?
P:\ is a shared drive which the SQL Server has access to so I doubt it's an access/privileges issue.