Post reply

Change connection string insde the package.

  • January 31, 2014 at 3:40 pm

    #303672

    I've 500 packages in a project. All of the packages have two connection managers pointing to Database A and Database B. I would like to make A to point to D and B point to E. Is there a easy way to do this rather than opening up separately and updating the connection managers. BTW, these don't use configuration files.

  • January 31, 2014 at 3:53 pm

    #1685242

    I'm not sure if it would work, so keep a backup of your packages.

    As SSIS packages are basically XML files, you could use Notepad++ (or another text editor that allows it) to "Search in Files" and use the replace option. The easiest way to do it is by using Ctrl+Shift+F.

    I use this to find items in files, but I have never used it to update them. You'll have a long time to save all the changes as well.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply