How do I get a report on the execution of an SSIS Package

If you want an execution report of an SSIS package, you can use the code below. It will generate a dataset for the last execution report of the SSIS package you want.

I think the toggles speak for themselves but just in case, here’s a little overview.

  • PackageName: Yes, this is the name of the package you want a report on
  • Verbose: This will show as much info as possible
  • ShowValidationMessages: Shows validation messages
  • ShowErrorMessages: Shows error messages. Turn all the other SHOW options off and this on to only see error messages
  • ShowInfoMessages: Shows info messages.
  • ShowAuditMessages: Shows audit messages
  • ShowLatestMessagesFirst: Shows the latest messages first