Hi,

We have a situation here where a consultant has come in and developed
approximately 45 complex DTS packages on the development server (lets
say its called SERVER1DEV). Within an unknown number of the packages,
there are references to SERVER1DEV.

I want to make a working copy of the database on a laptop computer
(believe it or not). The SQL Server is called LAPTOPSERVER. I have
all the software installed on it; however I need the DTS packages on
the laptop in order to load, build, and update the data warehouse
system from the source data files.

I have used a product called DTSBackup2000 to copy the DTS packages
from SERVER1DEV to LAPTOPSERVER, however within the DTS packages on the
laptop - they are still referring to SERVER1DEV, whereas I need them to
refer to LAPTOPSERVER.

Any ideas (apart from visiting each DTS package) how I might change the
server names over in order to make a working copy on the laptop?

TIA

Leigh

In message <1116846295.616353.88170 (AT) g43g2000cwa (DOT) googlegroups.com>, Leigh
Gardner <leighmgardner (AT) aol (DOT) com> writes
Where the packages not designed with this situation in mind? You can use
various methods to abstract the connection or set the connection at
run-time, e.g. use aliases, Udls, Dynamic Properties Task (Ini files,
SQL query, registry)

If you are now stuck then you can write some code to open the package
and change, but it will loose layout an annotations. For some sample
code see the Transfer Packages Sample Application

Tools & Tasks
(http://www.sqldts.com/default.aspx?272)

Or

Open, change, save, by hand.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org