August 26, 2008 at 8:14 am
hi guys. i have a job which executes a ssis package to makes a copy of a flate file using a file system task and then export the file into a shared drive. This job has been working perfectly for over a year. But i suddenly started getting this error when executing the job :
Error: 2008-08-25 12:58:36.59 Code: 0xC002F304 Source: Copy Template File File System Task Description: An error occurred with the following error message: "Exception from HRESULT: 0xC0010014". End Error Error: 2008-08-25 12:58:36.59 Code: 0xC0024107 Source: Copy Template File Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:57:03 PM Finished: 2:58:36 PM Elapsed: 92.843 seconds. Process Exit Code 1. The step failed.
when i execute the ssis package from Integration services it runs perfectly, the problem now is when the job runs. the permissions for the agent have not changed. Can someone point me to the right direction please?
August 27, 2008 at 10:24 am
The job runs fine for YOU, but not for the account that is running the job. This should be whatever account is running sqlagent.
Sometimes I'll log on as sqlagent and try running my job or getting at all the shares to see what the problem is.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply