How to add new columns to Flat File conn in SSIS without resetting data types for existing cols

ssis ssis-2005
adolf garlic picture adolf garlic · Nov 8, 2011 · Viewed 18.9k times · Source

SSIS 2005

I have a flat file connection which is the result of a db dump.

New columns have been added to the file and now they need to be added to the connection manager.

There are a lot of columns and not all of them have the default dataypes

How can I make it see the additional columns without doing a full refresh, thereby causing all the datatypes to reset?

Answer

David Benham picture David Benham · Nov 8, 2011

Open the flat file connection manager and go to the Advanced tab.

If the new columns are appended to the end of the flat file, click New. Otherwise highlight the existing column name positioned before the new column, click the double down arrow next to the New button, and select Insert After.

Once the new column is added, you can select it and modify the properties of the column (IE Name, Datatype, Length).

Related questions

Assign value to SSIS Script Component new Output Column

I'm sure this is a simple issue, but I'm trying to combine 2 columns into a new output column, but have not had any luck with it. Each time I get an 'Object reference not set to an instance of an …

Read More
Default Buffer Max Size and Default Buffer Size in SSIS

Is there any relationship between Default Buffer Max rows and Default Buffer Size in SSIS. How to supply values to these property parameters? I mean is there any propossionality in between these ?If I double the buffer size double then …

Read More
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More