Add logging to SSIS packages

Add the following code to the OnPostExecute, OnPreExecute, OnTaskFailed and onWarning events.

Use an expression for the SQLstatementSource

Add the following code to the OnError event: (difference is the errorCode value).

Use an expression for the SQLstatementSource

 

Create this table:

 

Use this query to build a log report

Leave a Reply

Your email address will not be published. Required fields are marked *