Hey Mike,

I am glad to hear you single-handed solving the issue because I am still fighting with it. My developer's SSIS package DOES have a lot of "Sort" transform....

Hi Mike,

If your SSIS package is running on x64 Windows 2003, please check the following link

http://support.microsoft.com/default.aspx?scid=kb;en-us;931846

I am having the same issue, unfortunately, none of the methods in the...

I have the same problem as Mike, the worse part is I do a "Kill [spid] WITH STATUSONLY" and it said it needs 188246 second (approx. 52 hours).  Apparently I...