SSIS ERROR LOGGING

• iamsql1

  SSC Eights!

  Points: 817

  More actions

  February 21, 2013 at 1:21 am

  #268898

  Hi

  can some body guide me best way to ERROR LOGGING in SSIS?

  Thanks in Advance

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  February 21, 2013 at 7:56 am

  #1589975

  You might want to take a look at Andy Leonard's blog on creating frameworks for SSIS.

  http://sqlbits.com/Sessions/Event9/Designing_an_SSIS_Framework

  You could also take a look at this book. Chapter 2 has a very good section on building a framework with a lot of logging

  http://www.amazon.com/Microsoft-Server-2008-Integration-Services/dp/0470525762/ref=sr_1_1?ie=UTF8&qid=1361458550&sr=8-1&keywords=ssis+problem+design+solution