|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SSIS Package through SQL Agent JobsI 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? 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? |
|||||||||||||||||||||||