Home Forums SQL Server 2008 T-SQL (SS2K8) SSIS Package Inside Trigger keeps running endlessly RE: SSIS Package Inside Trigger keeps running endlessly

  • October 18, 2012 at 3:42 am

    #1550359

    Hi Sam,

    I changed the properties of my package as you suggested. But, it didn't improve anything. I am adding an image which shows the various current sessions on the table and the it shows that the session of the SSIS package is being blocked by the session of the Insert.

    The image might provide a better view of the Blocking problem.

    SPID 66 is the Insert Query and SPID 71 is the SSIS task which is being blocked by SPID 66 and gets suspended.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉