SQLServerCentral / Discuss Content Posted by Kevin Feit / Article Discussions / Article Discussions by Author

Portable DTS Packages

Kevin Feit — Sat, 30 Nov 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kfeit/portabledtspackages.asp

Portable DTS Package

Philippe Cand — Fri, 20 May 2005 14:00:00 GMT

Hi,

I must miss something fundamental here.

When I need to make a DTS package "portable" from dev to QA then Prod, then I create all datasources to refer to an alias which is mapped in the machine Client Network Utility. When the time comes to move the DTS package to another server, i use DTS backup 2000, select source server, destination server, select all the packages i want to move, click trabsfer and voila. it is done.

Am I off-topic?

DTS backup 2000

http://www.sqldts.com/default.aspx?242

Cheers,

Philippe

Importing relational tables using DTS

KeithDavies — Wed, 14 May 2003 17:23:00 GMT

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!