Import relational data into SQL using DTS

• KeithDavies

  SSC Veteran

  Points: 287

  More actions

  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
  
  

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  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

  .