question

hodkinss avatar image
hodkinss asked

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?

ssispackage
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RBarryYoung avatar image RBarryYoung commented ·
What's the error message?
0 Likes 0 ·

3 Answers

·
Blackhawk-17 avatar image
Blackhawk-17 answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

hodkinss avatar image
hodkinss answered

Not as far as I am aware. I created the job using a domain account which has sysadmin rights on the server

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image Blackhawk-17 commented ·
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.
0 Likes 0 ·
hodkinss avatar image hodkinss commented ·
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.
0 Likes 0 ·
sp_lock avatar image
sp_lock answered

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

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

hodkinss avatar image hodkinss commented ·
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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.