Edit Variable Expression --> Exception



In one of my packages I'm getting an exception when trying to use the BIDS Helper variable expression editor. If I open a new project and create a variable, it works fine. Image of error is attached.
Using Win7 Enterprise SP1, SSDT (SQL 2012), BIDS Helper 1.6.1 (used exe installer).

What info can I provide about the package, what's relevant for this kind of error? I tried different names and types of variables, always same exception.

file attachments

Closed Jun 14, 2013 at 1:06 PM by furmangg


DarrenSQLIS wrote Oct 28, 2012 at 12:24 PM

Would it be possible to send me the package or a cut down package that still errors?

Alternatively what data types do you have for variables and any parameters? What values do you have?
Is it all variables in this package or just one?

BDee wrote Nov 5, 2012 at 12:31 AM

I think I managed to figure it out. Follow these steps:
  1. Create a new project
  2. Create a project parameter. Set Sensitive to True (this seems to be the cause or the error).
  3. Create a variable in the package and try to use BIDS Helper variable expression editor --> you should get the error.

DarrenSQLIS wrote Nov 6, 2012 at 2:07 PM

Thank you, found the issue with sensitive parameters. For an interim fix please see the attached zip, which contains updated DLLs. Extract the DLLs and overwrite the existing files in -
C:\Program Files (x86)\BIDS Helper 2012.

DarrenSQLIS wrote Nov 6, 2012 at 2:08 PM

Hot fix build

furmangg wrote Feb 26, 2013 at 2:17 AM

This fix will be part of forthcoming release 1.6.2