Post reply

SSISDB catalog View to determine the execution length of each control flow tasks

  • September 10, 2014 at 1:49 am

    #310860

    Hi all,

    This may be a simple question but I'm having a terrible day thus far and can't seem to find the answer. How would you determine the execution time spent by each control flow task in a SQL Server 2012 SSIS package that uses the project deployment model?

    catalog.execution_component_phases gives me the time spent by a data flow component in each execution phase but what I need is the time spent by a control flow task. Also the total time executed by the package would be helpful. Is there a catalog view or a combination of views that could do this?

    Thanks

  • September 10, 2014 at 2:12 am

    #1744342

    Have you tried looking at the 'All Executions' report for the package?

    More info here.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 10, 2014 at 2:30 am

    #1744344

    Thanks; on a good day I would have remembered this. Oh well.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply