There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Edit Variable Expression in VS 2010 with BIDS Helper 2012 1.6.0 does not refresh result from expression in Task
if you create an Variable with Expression for e.g. for an SQL that is used in a dataflow or an SQL Task the changes you make to an Expression are not used while starting in debugging mode.
You can recreate this phenomenon:
Create an Variable with Expression with an bad SQL statement.
Use an Execute SQL-Task or a Dataflow OLE-DB Connection (SQL Server) that uses the SQL-Variable.
Execute in Debug-Mode. An error will raise.
Fix the SQL to an "good" SQL with "Edit Variable Expression" an start Debug Mode again. You get the same error then before. If you View the current value of the Variable everything seems fine.
However if you reopen the dtsx-Package or change the SQL with MS build-in Expression Editor and Debug again everything will be fine.
I guess this issue is not only appling to SQL Variable but to all Expressions