August 11, 2008 at 6:39 pm
SSIS outputs a table to a TXT file. But when I recreate the table with a new colunm in the middle (not in the end). SSIS is not producing the TXT file with the new column in the middle but in the end. Any way to fix this. I have to remap all the columns in the Flat File Destination in order to have the new column output in the middle. Is there any good way to control the ouput of the columns?
August 12, 2008 at 3:46 am
Hi,
It isn't the flat file destination component that controls the format of the file. It simply controls the mapping.
If you need to have the column in a particular position, use the advanced tab of the flat file connection manager and just to the right the "new" button you will see an arrow giving you options for where you want the column to go.
HTH
Kindest Regards,
Frank Bazan
August 12, 2008 at 10:07 am
THANK YOU FRANK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply