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.
1,857 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee


    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.

    No comments