sql server dts: I created and tested DTS packages on my local server and everything worked
fine, the I copied the packages to our Test server using DTSBackup 2000 from
http://www.sqldts.com/default.aspx?242. Now I can not execute the packages
directly. If I create a job on the Test server, the Job sucessfully runs the
DTS package. Is there a way to run the DTS packages on the Test server
without using Job to do it?

TIA
Dean

If you are connecting to the server you copied the package to from
Enterprise Manager and trying to run the package, check to see that it is
configured properly. When you run the package on the server as a job it
runs local to the server. When you run it while connected from a remote
machine then the package runs on the remote machine.

Can you got to the server itself and run the package? Do you have the
connection properties to any SQL Server connection pointing to the server
name or local? This can cause a problem when run from a client machine.

Rand
This posting is provided "as is" with no warranties and confers no rights.