July 7, 2013 at 1:26 pm
Hi All,
I am searching for some help on editing the SSIS packages as XML files, Here is the scenario, I have around 50 packages(All the packages use OLEDB connections and has servername and Database name properties) now I need to modify the connection properties of these oledb connections like change the Connection name and have to add connection string property to it, with out opening the packages in SSIS I want to automate the process of changing these using a script task in SSIS or Command files. What is the best way to do it.
Appreciate your help.
July 7, 2013 at 3:18 pm
Are we talking about package configurations?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 7, 2013 at 8:08 pm
Hi Koen,
It is not about package configurations, This is only for one time use on the same env , I want to change all the packages permanently in single shot using a script such that the properties of the connection should change
July 7, 2013 at 10:49 pm
I think you'll need to write some code. Here[/url] is a starter - you'll have to expand on it to get it doing what you want.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply