SSIS SCENARIO

• maheshkrishnas

  Ten Centuries

  Points: 1045

  More actions

  April 3, 2012 at 1:14 am

  #271476

  hi all,

  What techniques should i consider to add auditing to my packages? I required to log when a package fails and how many rows were extracted and loaded in your sources and destinations in SSIS.

  can anyone help....

• nagireddysdd

  SSC Veteran

  Points: 227

  More actions

  April 4, 2012 at 9:58 am

  #1468985

  place execute sql task create one variable package level and use row count transformation

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  April 4, 2012 at 11:26 pm

  #1469319

  SSIS: Custom Logging Using Event Handlers

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