Post reply

find out which step is hanging

  • April 12, 2013 at 9:21 am

    #276320

    Here is the scenario...A sql Job is running which executes a SSIS package...but its hanging......This SSIS package other multiple SSIS packages within it....Is there a way to tell which package is culprit?

  • April 12, 2013 at 9:35 am

    #1606026

    The program name column in sp_who2 may give you a clue. If not, and you are familiar with what the packages do, use DBCC INPUTBUFFER to get the command that is causing the delay. That may point you towards the guilty package. Or you could enable logging in your packages.

    John

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

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