DTS select/insert with Identity insert

• AlGill

  SSC Enthusiast

  Points: 182

  More actions

  July 7, 2004 at 3:21 pm

  #85846

  I want to use DTS for data conversion; however I want to do something like the following T-SQL:

  SET IDENTITY_INSERT ON

  GO

  SELECT

   Id=CAST (c.Idn AS INTEGER),

  I.e. I want to load the result identity field with the old data from the source table.  DTS doesn't seem to allow me to have the multiple statements.

  Suggestions for using DTS to accomplish this?

  Thanks,

  Al

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  July 9, 2004 at 9:21 am

  #514113

  Hey Al,

  See the replies in the DTS forum. 

  Greg

  Greg