Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Execute SQL Task hangs Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 7:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 9:38 AM
Points: 1, Visits: 7
Hi,

I am using Execute SQL Task (EST) in my SSIS package. In this EST, the SQL Statement is to delete some rows from one table. The SSIS package works fine for long time. But there is one strange thing happened yesterday and today. When I run the package, EST hangs there. No error message. The package just doesn't go further. If I run the statement directly in SSMS, it gives result in 2 sec. And the SSIS package is scheduled to run nightly. In schedule job at night, there is no hanging. Only when I execute either whole SSIS package, or only EST task, it is stuck.

My environment is SQL Server 2005, BIDS 2005 SP1. Could someone please give me a hint why it happened?
Post #1386928
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse