I have a DTS package that contains more than 20 subpackage.Is it possible to change the data source of the main DTS package? Otherwise I have to change data source of each of the subpackages.
Unless the packages use Microsoft Data Link files (.udl) or pass the connection info in a global variable to the child packages, you'll have to change the connection in each package.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply