Object reference not set to an instance of an object.



I'm getting the error below when I click on the button "..." to edit variables expressions on the SSIS package.

I'm using VS 2015 Professional.

BIDS Helper

Object reference not set to an instance of an object.

at Konesans.Dts.ExpressionEditor.RuntimeHelper.GetVariableStringValue(Variable variable)

at Konesans.Dts.ExpressionEditor.Controls.ExpressionEditorView.TreeViewAddVariable(TreeNode parent, Variable var)

at Konesans.Dts.ExpressionEditor.Controls.ExpressionEditorView.PopulateFunctionsTree()

at Konesans.Dts.ExpressionEditor.Controls.ExpressionEditorView.Initialize(VariableDispenser variableDispenser, Variables variables)

at Konesans.Dts.ExpressionEditor.ExpressionEditorPublic..ctor(Variables variables, VariableDispenser variableDispenser)

at Konesans.Dts.ExpressionEditor.ExpressionEditorPublic..ctor(Variables variables, VariableDispenser variableDispenser, Variable variable)

at BIDSHelper.SSIS.VariablesWindowPlugin.EditExpressionButtonClick(Int32 selectedRow, Int32 selectedCol) in C:\projects\BIDS Helper\dev\bidshelper-vsix\SSIS\VariablesWindowPlugin.cs:line 453

Thanks for your work :)

file attachments


furmangg wrote Mar 6 at 2:52 PM

Can you go to Help... About Microsoft Visual Studio... Copy Info... then paste it here? My Integration Services version shows as 13.0.1601.5 and BIDS Helper is version 2.0.1 and I can't seem to repro this.

fpmorais wrote Mar 6 at 4:13 PM

Microsoft Visual Studio Enterprise 2015
Version 14.0.25431.01 Update 3
Microsoft .NET Framework
Version 4.6.01586

Installed Version: Enterprise

Architecture and Modeling Tools 00322-80000-00000-AA627
Microsoft Architecture and Modeling Tools

UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.

Microsoft Visual Studio Tools for Applications 2015 00322-80000-00000-AA627
Microsoft Visual Studio Tools for Applications 2015

Visual Basic 2015 00322-80000-00000-AA627
Microsoft Visual Basic 2015

Visual C# 2015 00322-80000-00000-AA627
Microsoft Visual C# 2015

Visual C++ 2015 00322-80000-00000-AA627
Microsoft Visual C++ 2015

ANTLR language support for Visual Studio 1.1
ANTLR language tools for Visual Studio includes IntelliSense and more... eventually...

Application Insights Tools for Visual Studio Package 7.18.00214.2
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 2015.1 (Beta8) 14.1.11107.0
ASP.NET and Web Tools 2015.1 (Beta8)

ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/

BIDSHelper Extension 2.0.1
BIDS Helper 2016 Visual Studio Extension v2.0.1 - An add-in to extend SQL Server Data Tools

Common Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Devart SQL Complete 5.5.218
Devart dbForge SQL Complete for Management Studio and Visual Studio
Copyright (c) 2016 Devart. All rights reserved.
Web: http://www.devart.com/dbforge/sql/sqlcomplete
Support: http://www.devart.com/dbforge/sql/sqlcomplete/support.html
Ordering: http://www.devart.com/dbforge/sql/sqlcomplete/ordering.html

GitExtensions 1.0
Git Extensions is a graphical user interface for Git that allows you to control Git without using the command-line

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools

NuGet Package Manager 3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Analysis Services 13.0.1701.8
Microsoft SQL Server Analysis Services Designer
Version 13.0.1701.8

SQL Server Data Tools 14.0.61021.0
Microsoft SQL Server Data Tools

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 13.0.1601.5

SQL Server Reporting Services 13.0.1701.8
Microsoft SQL Server Reporting Services Designers
Version 13.0.1701.8

TypeScript tools for Visual Studio

furmangg wrote Mar 8 at 12:28 AM

Same versions as I have. I tried to repro again and had no luck. Can you describe your sequence of clicks. How do you launch the Variables window? What options are selected? Showing variables from all scopes? Showing system variables? What tab are you on in the package? Control flow? Data flow? Event handlers? What are you clicked on in the SSIS package? The package background? A data flow? An event handler? Is the package in debug mode (running)? Is it SQL 2016 target server version or an older target version?

fpmorais wrote Mar 8 at 9:31 AM

The steps I take are:
  • Open a package
  • Right click on Control Flow background
  • Choose option Variables
  • Click on the "..." to edit one of them
At this point a pop up appears with the error message I've pasted above.

I've found a clue. This happens only when I have an object variable without a defined value. As this is a generated project with EzApi I'm probably not initializing the variable as I should.

Sorry and thanks for your help :)

fpmorais wrote Mar 8 at 9:37 AM

Please mark this as Resolved.

Thank you very much.

furmangg wrote Mar 8 at 11:37 AM

Glad you figured it out. If you will upload a small sample package I can fix the bug in BIDS Helper.

fpmorais wrote Mar 8 at 4:45 PM

I don't think a normal user can create a variable without a Type Value, so I don't think this is a bug.

Even so, for you reference in the zip file you will find two packages, one with the bug and the other without.

Thank you again for your time


wrote Mar 8 at 4:47 PM

wrote Mar 8 at 4:47 PM