Enabling DataFlow Profiling

All you have to do to enable profiling of DataFlow is using the correct parameters in the DTLoggedExec invocation.

When you run DTLoggedExec you have to specify that you want to have the DataFlow profiling active with the /PDF (or /ProfileDataFlow) option. When you use this option you must also specify where you want the file - containing DataFlow profiling data - produced by DTLoggedExec to be put. You'll specify the target folder with the parameter /PP (or /ProfilePath) option. You also have to specify the name of the file that will be produced. To do this the option /PFN (or /ProfileFileName) has to be used. In this last option you can specify the file name also using some particular tokens that will be substituded with run-time values.

More information on these parameters can be found in the Command Line Parameters page. Be sure to check it out.

So, if you want to execute a package that is available at "C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\TestPackage4.dtsx" and you want to save DataFlow profiling data to the folder "C:\DTLoggedExec\DataFlowProfile" with a file name set to TestPackage4 and you also want that the file name contains the date and the time at which the package has run, this will be your DTLoggedExec invocation (supposing you're using the directory tree proposed in the Download and Install page):

"C:\DTLoggedExec\bin\Any\DTLoggedExec.exe" /FILE:"C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\TestPackage4.dtsx" 
/LE:E /PDFN:"C:\DTLoggedExec\DataFlowProfile\{filename}_{date}_{time}"

the result will be a file like this one:

TestPackage4_20080806_113130.dtsDataFlowProfile

Note that the extesion ".dtsDataFlowProfile" will be added automaticcaly.

To learn how if can use this file, just read the Consuming profiled data page.