Finding out time taken from each task in SSIS pacakge

Anonymous
2021-11-22T10:19:50.433+00:00

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
    2021-11-23T01:08:50.537+00:00

    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.

    No comments