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

Portable DTS Package Expand / Collapse
Author
Message
Posted Friday, May 20, 2005 2:00 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 11:24 AM
Points: 48, Visits: 273

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



BI Guy
Post #184282
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse