December 3, 2006 at 11:16 pm
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.
December 4, 2006 at 9:19 am
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"
December 4, 2006 at 9:31 am
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.
December 4, 2006 at 10:37 am
Please post samples or examples as where you are having issues. Please include table definitions, and data
December 4, 2006 at 11:23 am
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
December 4, 2006 at 11:33 am
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