SSIS package and job
I had three sequential packages which were run by three jobs every day. Last weekend first of the packages failed; there was no change from a DBA point of view.
I created a job which runs each package in sequence. The job failed again at the first step. The package runs to completion in debug mode.
Can anyone offer a clue?
Have the system administrators changed permissions at the file or share level on your source or destinations? Your account may have rights but the SQL services may not.
Not as far as I am aware. I created the job using a domain account which has sysadmin rights on the server
Please provide more details. Are your source and destination local or remote? What errors are being presented? What does the first job - at a high level - do? etc.
The source and destination servers are on our network here. The only error is that the job has failed 'The package execution failed. The step failed.' The first package collects data from the source application/server and drops into RAW data on the distination server. The next two packages transform the data and then this is displayed. The source application runs 24 7 and has not altered in anyway.
I reported a similar issue yesterday...
Rob suggested setting the proxy permissions. It didnt work for me but maybe it will for you/?
http://ask.sqlservercentral.com/questions/2171/ssis-package-fails-when-running-as-a-job
I have tried this this morning and I got exactly the same error. I am completely stumped as this job has been running for months until last weekend
