May 15, 2003 at 5:35 am
Is there an easy way to import relational tables using DTS. I can't use identity insert as the PK's are from an external database and may clash with existing ones. I have to modify the FK's with the new PK once inserted into the SQL db. I have a resolution using a mixture of lookups and Active X code - but this appears very complex. All the examples I have seen have used a single table or simply add records using Identity insert or SQL Insert Into. Any suggestions greatfully received!
Regards
Keith Davies
IT Consultant
Regards
Keith Davies
IT Consultant
May 15, 2003 at 6:09 am
I would use DTS to import the data with no modifications into (2 or more) holding tables. Then use TSQL statements to move the data into the live tables including the logic of assigning the parent/child relationships.
Regards,
Andy Jones
.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy