We have few packages where we have enabled logging to msdb (sysssislog). And events selected are OnError, OnExecStatusChanged, OnPostExecute, OnPreExecute, OnTaskFailed, OnWarning.
When running this package from BIDS solution, all the event log to the table. However, when it is deployed and run as a job only some of the events get logged to msdb. The package however does run correctly and the data is loaded fine.
What we want is that every time a package runs, we should be able to see that each of the task has succeded or failed (like we used to in DTS)
Could anyone advise on what the issue seems to be?
View Complete Post