Home All Groups Group Topic Archive Search About

SSIS Package through SQL Agent Jobs

Author
21 Jul 2006 4:26 PM
John
I am having trouble running SSIS packages through SQL Agent Jobs.  The error
I get is that the command line is invalid.  The command line is automatically
generated by sql server not by me.  I can manually execute the package
through SSIS, but not through an SQL Agent Job.  I even tried coping the
command line out of the SSIS package and pasting it into the SQL Agent Job
Command line where the type of job is an SQL Server Integration Services
Package.

Any ideas on how to fix this problem?

Author
21 Jul 2006 6:22 PM
John
I found the answer.  In case anyone else is interested see
http://support.microsoft.com/kb/918760/
Look at the "Method 2:..." heading.

Show quote
"John" wrote:

> I am having trouble running SSIS packages through SQL Agent Jobs.  The error
> I get is that the command line is invalid.  The command line is automatically
> generated by sql server not by me.  I can manually execute the package
> through SSIS, but not through an SQL Agent Job.  I even tried coping the
> command line out of the SSIS package and pasting it into the SQL Agent Job
> Command line where the type of job is an SQL Server Integration Services
> Package.
>
> Any ideas on how to fix this problem?

AddThis Social Bookmark Button