DFS 2008 with Sort on huge file fails

Dec 23, 2010 at 7:41 PM


I am using DFS 2008 as a Data Flow Source within SSIS (2008 data center edition). My data flow is simple Flat file to Flat file transformation with a "Sort" step in between.

For a smaller sized file (e.g. 1000 rows), it works fine. But, when I use file with 96,000 rows, it fails just after/during sort. (It seems, the process hungs).

Does anybody have this problem before?