DTS Connection Server Name - 05-23-2006 , 05:36 PM
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.
Re: DTS Connection Server Name - 05-25-2006 , 04:12 AM
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.
Re: DTS Connection Server Name - 05-25-2006 , 09:07 AM
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.