BULK INSERT Problem

• narayanan.1985

  Newbie

  Points: 1

  More actions

  November 3, 2009 at 6:29 am

  #136102

  Hi,

  I am using BULK INSERT to insert a file into table. I need to add two more column in the table. one for my own data which is common to all rows. and CURRENT TIME STAMP in another extra cloumn. How to do this.

  Thanks and Regards,

  Narayanan. G

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739010

  More actions

  November 3, 2009 at 8:03 am

  #1074279

  Add two columns to the tables, specify default constraints, use a format file with bcp or specify which data from the file goes to which columns.

  bcp/BULK INSERT is not a transformation tool. It's a high speed load tools. IF you need to transform data, use SSIS/DTS.