question

willy avatar image
willy asked

execute SSIS package via task scheduler fails

When I am schedule a SSIS package via windows task scheduler, it fails with EventID 12291. I can run the package via BIDS and at the command prompt. I need to know how I can debug this and see what the probelm is.
ssis
10 |1200

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

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Check the error codes why the task is failing. You can find info on TechNet here: [ http://technet.microsoft.com/en-us/library/cc774891%28WS.10%29.aspx][1]. Maybe its problem with Authentication. Did you try to start the the SSIS as an SQL Server Agent Job? If you schedule the SSIS package using agent job, you will have a detailed information about the failures and complete error messages in the history log of the job. [1]: http://technet.microsoft.com/en-us/library/cc774891%28WS.10%29.aspx
2 comments
10 |1200

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

Not sure I can, the server that is running integration services is not the same one that is running db services. The integration server does not have a sql server agent loaded, thus is was trying to run the package from a command line. Again it works from the command line just not as a scheduled task. thanks
0 Likes 0 ·
Did you take a look on the error codes on Technet site I provided? By identifying the error code you could imagine what could causes the problem.
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.