DTS question SQL 2000

  • I have 2 tables one table "A" is Staging Table which is in a de-normalize fashion & doesn't as any constraints or Identity column. Table "B" is DEV table which is Normalize & has PK & Identity column. my question is when i transfer Data from Table "A" to Table "B" it is not going to work & will fail due to constraint & identity. how i can resolve this issue, IDENTITY Column is must for me to, so as to have each customer with Unique ID & even though customers are repeated still they will have same ID. any help is appreciated. thanking in advance.

  • can you post table definitions and sample data?

    inserting new customers should not be a problem, except you need something in table "A" that uniquely identifies the customer that you can match to records in table "B"

  • Table "B" is empty but as all constarints like COL1 is Identity & PK. Alsi i have Table "C" which as Identity column & FK reference Table "B". So i am going to do Transfer/Bulk insert from Table"A" to Table "B" where Table "A" doesn't as any Identity or Constraints on column. i hope tghis will help whta i am trying to acheive. thanks for your help.

  • Please post samples or examples as where you are having issues. Please include table definitions, and data

  • Open the transformation task (the black arrow) properties. 

    On the last tab (Options) ...

    Check the "use fast load" checkbox. 

    UnCheck the "Check Constrainst" checkbox.

    Check the "Enable Identity Insert" check box

     

    MohammedU
    Microsoft SQL Server MVP

  • will try & update you , thanks for your help & time.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply