PROBLEM running SSIS package as a JOB

Question

Post reply

PROBLEM running SSIS package as a JOB

bsembhi

Old Hand

Points: 322
More actions
August 5, 2010 at 11:50 am

#144398

Hi
I trying to run the package as a job and its not running it gives me error as follows
"
JOB RUN: 'MHRosterVerification' was run on 8/5/2010 at 1:11:08 PM
DURATION: 0 hours, 0 minutes, 2 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by User ndtsa\Administrator. The last step to run was step 1 (MhRosterVerification).
"
I have the following steps for crrating the job
1) in the "General" i have Owner : ndtsa\Administrator
Category : {Unrecognized(Local)}
check box "Enable" was checked by default
2) Under "Steps" i Have step name: MHRoster....
Type: SQL SERVER INTEGRATION SERVICES
Run as: SQL AGENT SERVICE ACCOUNT
then under "General" tab Package source : File System
Package : i gave the path where package is stored
Under "Data Sources" tab initially none of the Connection Manager's were checked , when i saw the package was giving error I check these boxes, still running into problems.
Please help
Thanks
Balwinder

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

You may want to enable logging to the package as explained here and check those error messages.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

I think we need more information.

What does the package do? Does the package run in BIDS? What errors do you get?

Usually, when a package runs in BIDS but doesn't in a job, it is due to permissions.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

bsembhi Old Hand Points: 322 More actions · Answer 3

Hi

The package was developed in SQL Server BIDS and then deployed to SQL SERVER Management Studio under SSIS.

The package has tasks as follows

1. It runs the SSIS package named "XYZ" and then "ABC" next.

Instead running package separetly I have it run as one Package "Main" and this package "Main" has steps in 1 mentioned above. I have already menationed what errors I am getting in my previous post.

Thanks

Bsembhi