Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSIS Logging - few details w/ SQL Agent

Author  Topic 

ToddFields
Starting Member

1 Post

Posted - 2009-03-05 : 12:36:40
I have an SSIS package that runs all the configured events to a file correctly when running from BIDS. When I run it deployed and scheduled in a SQL Agent Job, I get few if any of the events in the same log. I'm running SQL Server 2005 RTM (no SP1 or SP2). I've tried to use DTExec and get the same results that nothing is logging.

Any thoughts on why SQL Agent is different than interactive.

I've also tried to turn on task level logging to see if there is a Inherit from parent issue, but this did not help.

Thanks,
Todd
   

- Advertisement -