Tracking Execution Time of each step?

CraigL77

hi,

i am currently in the process of moving a bunch of jobs into SSIS from another ETL tool. I would like to benchmark the two products against each other by comparing how long each step of an ETL process would take.

I see no way to do this in SSIS, there is the Progress tab but it doesnt list start/time and end/time. Plus I having loops and things which I want to know how long each iteration takes.

Is there a way to track all this

Thanks

Phil Brammer

CraigL77 wrote:

hi, i am currently in the process of moving a bunch of jobs into SSIS from another ETL tool. I would like to benchmark the two products against each other by comparing how long each step of an ETL process would take. I see no way to do this in SSIS, there is the Progress tab but it doesnt list start/time and end/time. Plus I having loops and things which I want to know how long each iteration takes. Is there a way to track all this Thanks

The progress tab does too list the start and end times.

CraigL77

Ah I see that now, its kind of hard to analyze from the Execution results view. Is there a way to output that information in some other format

Phil Brammer

CraigL77 wrote:

Ah I see that now, its kind of hard to analyze from the Execution results view. Is there a way to output that information in some other format

You can use package logging. Or write your own auditing table to track the results. To do that you'd use Execute SQL tasks to insert into that table start and end times on the control flow.

CraigL77

I think i found it under logging, looks like what I need.

Thanks