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