x

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, 2009 at 10:06 AM in Default

hodkinss gravatar image

hodkinss
33 2 2 2

What's the error message?
Nov 26, 2009 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, 2009 at 10:11 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(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, 2009 at 10:38 AM

hodkinss gravatar image

hodkinss
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, 2009 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, 2009 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/?

http://ask.sqlservercentral.com/questions/2171/ssis-package-fails-when-running-as-a-job

more ▼

answered Nov 26, 2009 at 05:32 PM

sp_lock gravatar image

sp_lock
9.1k 24 28 31

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, 2009 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x927
x27

asked: Nov 26, 2009 at 10:06 AM

Seen: 1068 times

Last Updated: Nov 26, 2009 at 11:57 AM