13

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

Craig
  • 11,614
  • 13
  • 44
  • 62
  • 1
    Look into the [derived column transformation](http://msdn.microsoft.com/en-us/library/ms141069.aspx). Your formula will just be a constant. – jason saldo Aug 28 '08 at 00:29

1 Answers1

25

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.

Farinha
  • 17,636
  • 21
  • 64
  • 80