Hey Harvey,

Thanks for the post but unfortunately I am not using a script task.

I did open a case with Microsoft and have since discovered it is an issue with the "sort" command and memory. MS has 1 other case that is similar to this and they have classified that case and this as a bug. Unfortunately, MS is focusing mainly on SQL 2008 and only issuing security fixes (for the most part) at this time. I was able to work around the issue by redesigning my package so I didn't push it with MS, either.

If I hear anything back I will post it here.

Best of luck!

-Mike