adding a column to a target table...using DTS

• sairah

  Old Hand

  Points: 399

  More actions

  July 30, 2003 at 8:01 am

  #106004

  hi there everyone,

  i want to add a column to the target table after Dts transformation ..and i want the column to keep a record of the number of values in the column in increasing order..i mean i want to some kind of autonumber thing as we have in Microsoft access.

  how can i do this ..could anyone guide me please..with a sample..or guide me how to write a code or anything tht would help.

  thnx..

  i had a reply reagrding this

  which said

  create table tbl_a (

  gen_id int IDENTITY (1, 1) NOT NULL ,

  field_x char (4) not null

  ) on primary

  You need to set the identity column to a starting value with the reseed ..

  but my problem is that i want..to add a column...after DTS into the target table..and while using DTS i do not get the option to update the table..and add a column..to it..so how to i do this..

  could anyone help..

• brendt hess

  Hall of Fame

  Points: 3256

  More actions

  July 30, 2003 at 10:10 am

  #467794

  An SQL task at the end of the process should do what you want. Add a new task step, and add an SQL Statement like:

  ALTER TABLE MyTable Add gen_id int identity

  This will add a new Identity column to your table, and, since it is an Identity column, it will be populated automatically.