Dear all,
I have built an SSIS package by using the BI Dev Studio and enabled its configuration xml file.
The package have a variable called TranDate and I want to put it dynamically from a Calendar on my website (just like assigning a variable).
I have successfully change the value of that variable in the configuration files (affected to the xml file).
Then I loaded the package and executed it (through my web). It's still get the old value (which I have assigned while creating the package).
I didn't understand that where else can the package get the value of that variable so it still get the old value (that value have never appeared in the xml configuration file anymore when I changed it).
Thanks for reading this, and I am looking forward to seeing any helps from you guys.
Indirectly config the Package but it didn't affected
Jean-Denis Langelier
hi, what do you mean by "by the time click the button Change" In general what you asking is very common usage of the configuration feature set, so I know overall it works. What I am guessing is your calendar application is updating the configuration file and then somehow calling he package Regardless, you want to reduce the problem set to as simple as possible to help trouble shoot.
For example...
1) manually edit the configuration file with some new value
2) save and close the file
3) manually execute the package via BI studio.
Does the proper new value get loaded from the configuration How do you verify Are you using a script task and a message box or are did you set a breakpoint and seeing the value in the locals/watch windows
icnagy
So you look at the value property of the variable itself and do not see the 'old' value What value is there The value in the configuration file is your desired new value Do you by chance have and 'property expressions' defined in the package that could result in the 'old' value SSIS will load configurations and then 'evaluate' expressions so an issue like this can commonly be the configuration is loading as desired its just an expression is then overriding the value.
Hope this helps
M. Mondok
The value in the configuration file is the new value by the time click the button Change. This variable has value and it's not an expression.
After change the configuration file, I open the package again. But the variable still have the old value. I wondered if I could let the value of the variable be blank. But that is an invalid action. The package couldn't be built successfully if I the value of the variable is blank.
I thought that I could have just changed the value of the variable then the package will get that new value immediately. But now I don't think so.
How can I config the package to force it to get the value of the variable from configuration file (not the default value in the wizards)