"Erick" <josefszeliga@hotmail.com> wrote in message
news:e109c9fd.0404291721.4dba2d12@posting.google.com...
> My DTS package requires that parameters be set depending on which of
> our sql 2000 servers the package runs on. ie the servername determins
> the name of the database in development, testing and production.
>
> I created a dynamic property task and used the Environment Variable
> "SERVERNAME" to retrieve the SQL servername. The worked out the
> database name base on the value returned
>
> This works fine if the DTS is exectued local on one the server it sits
> on. Howerver, if i open Enterprise manager on my pc and point it at a
> DTS package on one of the servers and exectue the DTS this way. It
> says the SERVERNAME is my local PC's name.
>
> Is there a way to capture inside a DTS the name of the sql server
> where the package you are trying to run is actually located on ? Not
> the name of the sql server that is calling it.

> My DTS package requires that parameters be set depending on which of
> our sql 2000 servers the package runs on. ie the servername determins
> the name of the database in development, testing and production.
>
> I created a dynamic property task and used the Environment Variable
> "SERVERNAME" to retrieve the SQL servername. The worked out the
> database name base on the value returned
>
> This works fine if the DTS is exectued local on one the server it sits
> on. Howerver, if i open Enterprise manager on my pc and point it at a
> DTS package on one of the servers and exectue the DTS this way. It
> says the SERVERNAME is my local PC's name.
>
> Is there a way to capture inside a DTS the name of the sql server
> where the package you are trying to run is actually located on ? Not
> the name of the sql server that is calling it.