SSIS load flat file to db

[jimguy999]

Hi,

In SSIS, i need to read a flat file (csv) and load into a table in a MSSQL 2005 db.

Doing the straight insert was ok. But there are more columns on the target table than the csv file. I am used to using a different ETL tool. In the tool I use, i would create a source or target transformation, and then set a value for the additional columns.

What I need to do create is the extra columns (a date field and a character field) somehow in the SSIS flow.

Any suggestions?

Thank you

[skhanal]

You can edit the data flow in business intelligence management studio to add values for missing columns.

[jimguy999]

In what part of the data flow?

I have tried to add a column to the flat file connection manager. It lets me add the column, but when I preview the data, the data disappears - i assume becuase there are no values for the column that I have added.

Where do i add the columns - in the flat file connection manager, or in the flat file source?

Thanks

Jim

[skhanal]

You can use Derived Column transformation to generate values.