Import a csv and map a literal value to a column

[PGO01]

I have an SSIS package that takes in a flat file (csv) and maps the columns of the flat file to the columns in a table. I have an extra column in the table that I want to map to a literal value.

Any ideas how to do this?

I have tried creating a variable, and entering a literal value - but it does not appear in the dropdown list in the mappings. All that appears there is the available columns from the csv.

Please help!

 

[MDXer]

Add a derived column to your data flow Add a new column and the assign the variable to that column.

 

[PGO01]

Got it, thanks.