Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

  • RE: Hanging-up of the Execute SQL Task

    I'm found solution, but I still don't understand the reasons. 🙂

    I'm changed the SQLStatement to next

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    DELETE...

    GO

    Thanks for the participation.

  • RE: Hanging-up of the Execute SQL Task

    Hm...interesting tip.

    I did it.

    When I replaced statement to something simple (like select getdate()) - component executed immediately.

    When I return original delete statement - component again executed infinite.

  • RE: Hanging-up of the Execute SQL Task

    Yes, I understand you.

    I'm looked to the Profiler and Activity Monitor (in SSMS) and I see only one statement which is executing while I'm not stop it.

  • RE: Hanging-up of the Execute SQL Task

    When I disable this component all work fine.

    And when I looking to the Profiler Trace I see the same query that when I execute it from SSMS

Viewing 4 posts - 1 through 5 (of 5 total)