Depending on the example, just change the server name and check the connection details in the LoadFromSQLServer call to load a package from another server.
Be aware that the package will then be executed on the web server under the urrent security context of IIS (IWAM_MACHINE) so it will need permissions to access the resources required by the package to execute.
"Javi" wrote:
Quote:
Hello, I've got a problem.
I have a ASP page in a Server, and I want to make a call to a DTS that is
stored in other Server.
All the examples I have seen are making the call being the ASP page and the
DTS in the same server. Is possible to do what I want? How?
Thank you for your help. |