CODEWITHSUNDEEP
sql-serverssisbusiness-intelligence
PNPTestovir
PNPTestovir

Reputation: 307

Execution time in SSIS

I ran my packages in a loop and I would like to have execution time of each loop iteration. Now (in Execution Results) I only have elapsed time for Sequence Container, for whole loop (not for every itearation). It's possible to increase level of time granularity?

I ran SSIS package from VS (I can't deploy SSIS project on server). I use SQL Server 2008R2.

Upvotes: 0

Views: 345

Answers (1)

sdrzymala
sdrzymala

Reputation: 387

You will need to add a custom loging mechanism. You can simple add a new derived column component and add a time span for each iteration.

Upvotes: 1

Related Questions