SSIS: Adding a constant column value when doing a CSV to SQL conversion

Question

I am reading in CSV file and translating it to a SQl Table. The kicker is that one of the columns in the table is a type ID that needs to be set to a constant (in this case 2). I am not sure how to do this.

Answer 1

Look into the derived column transformation. Your formula will just be a constant.

Answer 2

You can use a Derived Column Transformation in which you'll create a new output column and set its value to 2. You can then use that column when outputting to SQL.