Finding out time taken from each task in SSIS pacakge


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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,407 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points


    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.



    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.

    0 comments No comments