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?