Changing Connection Provider SSIS

  • Hi

    I am in the process of migrating to SQL 2008 from 2005

    I have had problems with response times with regards to connecting to a DB2/AS400 using an ODBC Data Provider.

    So I have moved over to using the new OLE DB Provider DB2. This increased the response time to my data flow tasks considerably.

    I use XML file package configurations.

    My question is, is it possible to change the provider I use in my package configuration file without having to go to all my packages and manually opening the connection managers and changing the provider there?

    Any help will be appreciated.

    Thanks

  • If you don't already have this property set up as part of a package configuration, or taking its value from a variable, then I don't think you can do what you're asking. However, if you have a lot of packages, it may be worth opening each one as an XML file (just use Notepad or some other test editor). You can then find the property you wish to change and update it according to your requirements. Be very careful doing this - I'm sure it's not a recommended method, but it may save you some time. Certainly you should make backups of all the files you're going to modify before you start.

    John

  • Didn't think it was really possible. Thanks for the suggestion

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

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