Changing DTS package data source

  • Hi folks,

    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.

    Please Help

  • 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