Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Importing relational tables using DTS Expand / Collapse
Author
Message
Posted Wednesday, May 14, 2003 5:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 13, 2007 3:53 PM
Points: 159, Visits: 1
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 a resolution using a mixture of lookups and Active X code - but this appears very complex. Any suggestions greatfully received!




Regards

Keith Davies
IT Consultant

Post #12216
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse