I am having this same issue with an SSIS package. The package is simply writing a database view to a flat file destination. It is translating from Unicode to UTF-8 in a data transformation step. SSIS hangs up in the PreExecute phase, fills up the TempDB, and fails. The underlying query on the view outputs one column of DT_NTEXT which is very wide, the data transformation step simply translates from DT_NTEXT to DT_TEXT then writes to a flat file. We put out one column because we need to trim each database column (due to messy data) and set up nonstandard delimiters on each column. Is there some database setting that does not like the wide row? The package executes fine with just a few records (top 1000 works), but as soon as I try the whole table, it hangs up and fails. The database is SQL Server 2008 R2 on a huge server.