InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 05:45:10 GMT20http://www.sqlservercentral.com/Forums/Topic12216-99-1.aspxIs 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 a resolution using a mixture of lookups and Active X code - but this appears very complex. Any suggestions greatfully received! Wed, 14 May 2003 17:23:00 GMTKeithDavies