Logging start/end times for Data Flow Tasks

• JimAtWork

  SSC Enthusiast

  Points: 145

  More actions

  November 13, 2006 at 11:59 am

  #114187

  Is there a way to configure the SSIS Log output to show the time it takes for ETL in a particular Data Flow Task when there are several in a Control Flow Task?  It seems the log output doesn't document the Data Flow Tasks separately (or I don't know how to do it).  For example, I have a Control Flow Task called Load Base Tables.  The Data Flow page on the Data Flow Task tab for that Control Flow has eight Data Flow Tasks on it.  The SSIS log for the Data Flow Tasks for that Control Flow Task doesn't show individual times the various events occurring for each of the Data Flow Tasks in a way that they are identifiable, although, when each is completed it logs the number of rows transferred and gives the date/time for that event (as well as the name of the Data Flow Task).

  TIA, Jim

  ---

  Kindest Regards,

  JimAtWork

• Dharmbir

  SSC Journeyman

  Points: 98

  More actions

  November 15, 2006 at 11:58 pm

  #672198

  Try executing the Package Through command line and redirect the output to file.

   dtexec Package.dtsx >> "d:\\log.txt"

  Or execute the package in designer and look the execution result in the last tab