Suppose my server name is MyServer001, but in order to access it from my
remote vpn, I need to refer to it in the package as MyServer001.ca.ge.org.

Will the package still run properly if scheduled? (being that the server
doesn't need to refer to it with the ca.ge.org when run locally?)

And - as a side question, why do packages run slower when initiated from the
client?- it seems as though it should have no effect because it runs on the
server.

Hello jonefer,


Naming is simply a way of finding the computer right so if on the scheduling
server you try to go to the name you give in the post does it work?

If not then you may want to change the name at runtime through a Dynamic
Properties task.

DTS is a client. If you run a packge on a client then the package comes
to you. This has huge implications if you use the Transform data Task.
Just because you open it from EM and it is sat on a server does not mean
it runs there. What you see is what is in the sysdtspackages table store.
Nothing else.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com