I have a DTS package on SQL 2000. This package requires a few local files that are specific to the host SQL server. Users may have Enterprise Manager on their workstation. I want to find the computer name that the user executes the package from and if it is not the correct host SQL machine, alert the user and exit the package. I just can't seem to find how to return the local computer name. I tried HOST_NAME and HostName but get no results.
I'm thinking dynamic properties task to query the environment variable COMPUTERNAME and put it in a global variable.. THen use activex script to interogate value and either succeed or fail based on logic..