Finding out time taken from each task in SSIS pacakge

Question

I need to log the time taken from each of my task during the execution of the SSIS package through SQL job. How can I do this?

Answer 1

Hi，

It seems that you have raised the issue before.

Check if those answers could resolve your issue here.

You may also refer these links to see if it is helpful.

https://www.mssqltips.com/sqlservertip/5243/tracking-execution-times-for-ssis-packages/

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/90d36744-84b3-475f-a107-7f9d4b093187/used-time-on-every-data-flow-ssis-task?forum=sqlintegrationservices

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.