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