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 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply