DTS Connection Server

Hi everyone:

I'm making aDTS for SQL Server 2000 and I need to know if there is a way to set the Connection taskServer 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.

To refer to local default SQL instance, you can use either '.' or '[local]; if you want to refer to named instance, you should add the instance name: '.\MyInstance'

|||Thanks for the reply Lori_Jay, but either '.' or '[local]' seem to work in the DTS Server Connection. To make it clearer I wrote '.' and '[local]' (without the quotes) in the Server TextBox (also a dropdown) and it didn't work cause the server was not found. It is only working with the exact name of the DataBase server.|||'.' or '[local]' that used in DTS Server Connection can only refers to SQL2000default instace. If you move the DTS package to a SQL2005 default instance, the connection will fail because the connection Provider used by the old DTS can not access SQL2005. In this case you can change the Data Source type to 'SQL Native Client' then try again.