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?

more ▼

asked Nov 26 '09 at 10:06 AM in Default

hodkinss gravatar image

33 2 2 2

What's the error message?
Nov 26 '09 at 02:09 PM RBarryYoung
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Nov 26 '09 at 10:11 AM

Blackhawk-17 gravatar image

11.8k 28 30 35

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Nov 26 '09 at 10:38 AM

hodkinss gravatar image

33 2 2 2

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.
Nov 26 '09 at 10:41 AM Blackhawk-17

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.
Nov 26 '09 at 12:33 PM hodkinss
(comments are locked)
10|1200 characters needed characters left

I reported a similar issue yesterday...

Rob suggested setting the proxy permissions. It didnt work for me but maybe it will for you/?


more ▼

answered Nov 26 '09 at 05:32 PM

sp_lock gravatar image

9k 24 27 30

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
Nov 27 '09 at 05:42 AM hodkinss
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 26 '09 at 10:06 AM

Seen: 996 times

Last Updated: Nov 26 '09 at 11:57 AM