How to store SQL Agent Job Step output messages

• Maique

  SSC Eights!

  Points: 913

  More actions

  November 12, 2008 at 9:02 am

  #126811

  I have been setting up notifications for every step inside a SISS package that send Success and Failure email notifications , I would like to change this process by saving this information to a SQL Table.

  Any suggestions in how can I acomplish this task, this will apply to every step inside a package..

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  November 12, 2008 at 9:21 am

  #897603

  Set up logging for the package, and then use the logging provider to point to a table.

  Moved to the SSIS forum.