Steve-3_5_7_9 (9/2/2010)
Can't you just prevent the truncation to begin with?I regularly deal with flat files because we interface with a mainframe. I use this approach.
Use a sql query, or stored procedure as your source and write the query to return the records in the proper format/field size. This way you wont have to deal with derived columns and such. You'll just have a source and flat file destination using this method.
Steve
That is correct you can even add configurations and delimiter agnostic export in your T-SQL or stored proc. The only issue I have the T-SQL to do this is very long.