Dataflow : Transformations : Execution Start time & End Time

• Marimuthu-129612

  Hall of Fame

  Points: 3332

  More actions

  April 23, 2008 at 1:21 am

  #184766

  SSIS Experts,

  How to log start time and End time of execution / Validation status of any Transformations or atleast asynchronous transformation (s) in SQL Server 2005 /2008 ?

  We need this information to trouble shoot Performance issue of SSIS Package which takes more time in UAT than in Integration boxes under same set up ( Physical and Logical )

  Thanks in advance.

  Regards

  Marimuthu

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  April 23, 2008 at 9:49 am

  #806146

  Right-click in an empty area of your control flow and select "Logging" from the context menu.

  You can configure your package to log to a number of different sources, but logging to a table makes it pretty easy to examine.