Logging in SSIS 2012

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  March 23, 2015 at 3:03 am

  #295277

  Hi ,

  I have been given one task to redesign the existing SSIS Package.

  In that SSIS package I would like to have logging for each table loading.

  Table contain below column.

  TableNameStartTimeEndTimeInsertedUpdated Status

  Please do let me know the way which can help me to achieve my requirement

  regards,

  Vipin Jha

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  March 23, 2015 at 5:23 am

  #1785655

  This article should get you started:

  Custom Logging in SQL Server Integration Services SSIS[/url]

  Although it's a bit overkill since SSIS 2012 comes with the SSIS catalog which has built-in logging.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP