SSIS load flat file to db

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

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

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

You can use Derived Column transformation to generate values.