SSIS - Update common Property for multiple objects (Find and replace)

  • Is there a way to do either a find and replace in the SSIS designer window for multiple objects such as the connection manager?

    I have a package that has numerous connection managers one for each text file being imported into a database. The location of the files (the folder path) has changed. I want a better way then going into each and every text file in connection manager and changing the path manually.

    Than You In Advance.

    JT

  • Sorry, Answered my own question...

    Open it in "Code" (XML) format then use find and replace.

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

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