Hello,

I have a scheduled job that runs an SSIS package. Works fine so far. In
that job, I add a second step that runs another SSIS package. If I run the
job, the 1st step runs well but fails as soon as the second step starts.
However, If I start the job and tell it to start at step #2, it runs fine.

The two tasks are distinct package not related to each other. I really
don't understand what the problem is here.

I don't understand the "logging" functionnalities also, If I try to enable
it and redirect the output to the Event Viewer, I have to specify which
"Connection" to log but nothing appears in my Event viewer.. I guess there
is something I missed...

Any help would be appreciated. So far, I've got so many problems with SSIS
job scheduling that I'm begin asking myself if I'm that dumb or if it is
bugged... I guess I'm dumb...

Hello Christian,

If this is part of a job then you may get more detailed error messages in
Agent's log if you use a CmdExec step type instead of the SSIS Job Step type

http://wiki.sqlis.com/default.aspx/S...dPackages.html


Logging is now directed towards connection managers and this gives a great
amount of flexibility beacuse with the aid of Property Expressions we can
shoose where to redirect the logging

BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/3f3bef92-be75-4ae7-92b8-063e43b63000.htm


Allan