Is there a way to call a dts and pass parameters to it.
we have written a DTS package on one server for one client, and want to use the same DTS package on another clients server, but the server names are not the same. is there a way to pass parameters, such as server name or anything else for that matter to a dts package?
The reason i need the server name is because the dts is running based on joins of tables on 2 seperate machines.
Start Free Trial
