August 16, 2010 at 2:16 am
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
August 16, 2010 at 2:30 am
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
August 16, 2010 at 2:44 am
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