Thanks Nick,

I appreciate the word from the school of been there, done that! I am going to try again to push for a comma delimited solution out of SS and...

But I need the output lines to have fixed length columns. So if the Header columns total 125 characters, each header line in the output file needs to be 125...

I'm not quite sure how to get the output to be fixed length. I started by generating comma delimited output as described here:

http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/25/multi-record-formated-flat-file-with-

ssis.aspx

where you create a single derived...

I dont' have any ODBC data sources to work with here, but in my one SSIS Package, if I right click in the Connection Managers area and choose "New Connection..."...

After typing in the new name for Column 0, Shift+Tab will take you back to the column list. Down arrow to the next column, and then two Tabs and you're...