Post reply

Import relational data into SQL using DTS

  • May 15, 2003 at 5:35 am

    #105716

    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

    #457238

    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 1 (of 1 total)

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