SSIS 2008 R2
I’m a relative newbie to SSIS but a long time developer / dba.
I have developed several packages that I execute from stored procedures, via the cmdshell,
and I want to capture any error messages that come from the actual execution.
Ideally I would check a sql table for any error results.
I found SSIS > Logging on the Menu bar and created a Sql Server log (in the same database as I am executing the sp from).
In the Configure SSIS Logs, I created the appropriate entry on the Providers and Logs tab and on the details tab I selected only the OnError check box.
All well and good. After an execution I find the sysssislog table in the system tables.
What I did not expect to see was the Begin Execution / End Execution rows for the package just executed.
I only want errors to show up however I have not yet tested an error situation.