Manually adding new column into Flat File Connection Manager and column order

Flat File connection Manager can be manually modified to add a new column or remove existing columns, there is no need to Rest Columns which removes the customization done on existing columns.
Be careful and make sure to insert new column at the appropriate order to avoid column mismatch.

SSIS Does not read column names and read the data in same order but just pulls the data and assigns to the columns we have created.

User the button highlighted below to add new column in specific order.
FYI:
Adding_New_Column_To_FlatFileConnectionManager

My experience:
I had a package which reads the data from Intacct and pushes into Text file and this data is processed to SQL Server. I had to add new column! I just added new column at the end in my Intacct column list expecting new column will be the last one in my text file. New column was added in a different position which created data discrepancy.

Advertisements
This entry was posted in SQL Server, SSIS and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s