Hi everyone:

I'm making a DTS for SQL Server 2000 and I need to know if there is a way to
set the Connection task Server property to something like 'local' or
something like it so I don't have to change the Server property everytime I
Install and run the DTS on a different server than the one where I built it.

Thanks.

--
JPortela
..Net developer

Hello Jportelas,

Have you tried using (local) or localhost?

It would appear to work although I have had occasion where even when doing
that the package thought it was actually on my dev box.


If you want to get rid of any ambiguity then why not have an external configuration
to do the setting for you like a Dynamic Properties task or I even use an
alias in CliConfig. Others use Host files.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan and Thanks for the reply.
Either (local) or localhost worked for me, the connection could not locate
the server by this name so I had to put the server name back again.
Thanks also for the suggestion on the external configuration, but I don´t
need to go that far.
Thanks.

--
JPortela.
..Net developer