Is there a way to determine the name of the SQL Server instance to which a
DTS package is stored?

I would like to be able to determine the instance name so that I can set the
properties of a connection object to that instance name. My aim is to be
able to store a dts package on each instance of SQL Server on a given server
and have each package access databases on the instance it has been saved to,
each instance having the same set of databases.

Help!

Kind Regards,
Doug

The problem with this method is that DTS is client side so if you execute it then the package comes to you regardless of where it is
saved. In a job then the problem is easy to solve because it executes on the local server.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"DougHolland" <DougHolland (AT) discussions (DOT) microsoft.com> wrote

In message <B80FC3FA-5B15-4859-8DFB-3EFE3C12C48A (AT) microsoft (DOT) com>,
DougHolland <DougHolland (AT) discussions (DOT) microsoft.com> writes
If you execute the package on the server where it is stored, through a
job for example, use (local) as the server name. But as Allan says, DTS
is client side, so think through the implications of this, particularly
when developing.


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

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

Thanks to both Allan and Darren for your help. I had thought of that myself
as a respone to the issue we were having and in the end a decision was made
to use separate servers for these different environments so the issue
vanished.

An even easier solution!

Doug

"Darren Green" wrote: