August 21, 2011 at 12:06 pm
New to SSIS.
If I create a xml configuration file and include the package variables in my packages, and later if the variable value changes, I change it in the design view for the variale value.
will the xml configuration file automatically pick up the change or I have to manually go to configuration file to change it there as well?
Thanks
August 22, 2011 at 8:16 am
If you're asking that when you update/change a variable's value in BIDS, will the associated xml config file be similarly updated, then no. If you update the variable within BIDS and run the package (assuming the xml config is available), the package will run with the config file's value, overriding the value you entered in BIDS just before you ran the package.
If you want the config file to pick up the new value, you either need to update the config file manually or re-export the configs to the same xml file.
August 22, 2011 at 8:26 am
...to change it there as well?
Not 'as well' - just change the config file and leave the BIDS version alone.
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.
August 22, 2011 at 7:43 pm
Thanks, you both answered my question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply