2

Closed

Edit Variable Expression in VS 2010 with BIDS Helper 2012 1.6.0 does not refresh result from expression in Task

description

Hi,
 
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
Closed Jul 10, 2012 at 6:59 PM by furmangg
I checked in a fix for this. The fix should be in upcoming release 1.6.1.SSIS2012 contains an undo feature and that caused them to change some of the APIs we had been using.We need to take a look at whether BIDS Helper features should support undo in the future. And we need to analyze the rest of the SSIS features to make sure they all use the proper "mark the package as dirty" code.Thanks for reporting this.

comments

DarrenSQLIS wrote Jul 4, 2012 at 8:31 PM

Thank you for reporting the issue, and for the detailed repro steps. I can reproduce this and am now trying to work out the cause.

furmangg wrote Jul 5, 2012 at 3:13 PM

SSIS2008 is marking the package dirty (so you have to save, and so the updated package gets used when you next debug it). SSIS2012 BIDS Helper isn't marking the package dirty.

FixedWidthColumnsPlugin.cs does seem to be successful in marking the package dirty in SSIS2012, so you might take a look at that, Darren.

furmangg wrote Jul 5, 2012 at 3:14 PM

The workaround is to make some other small change outside of BIDS Helper which will mark the package dirty, then save. You might use that for the time being.

Thanks for reporting this issue!

Sign in to add a comment