This project has moved. For the latest updates, please go here.

Object reference not set to an instance of an object

Apr 5, 2010 at 2:58 PM

I am trying to use this on a 64bit Server 2003 R2.  SQL 2005 SP2 database, and I am using the 2005 install.  The package installs, I can add it to the toolbox and can drop it onto a data flow page, but when I try to open the task to configure it, I get an error window that says "Object reference not set to an instance of an object".  I have verified that I see the DLL in the Pipeline folder and I can see it in the windows\assembly folder.  I'm not sure where to go from here.  I have successfully installed and configured it on a 2008 Server, SQL 2005, 32bit.

Coordinator
Apr 5, 2010 at 10:45 PM

Jeremy,

Sounds like the component is installed, but I haven't see that issue before.  It may be the x64 to x32 Thunk between the OS and the BIDS GUI.

Can you check if there is a copy of the DLL in the (x86) Pipeline folder.  If not, can you copy it there, restart BIDS and see if that corrects the problem?

I haven't had issues on other x64 (Windows 2003, Vista, Windows 2008 R2) platforms, but they have been SQL 2008, or SQL 2005 and SQL 2008...

 

I will have to build that environment to test in, to assist me in setting up the test environment, can you please do a Help About within BIDS, and post the "Installed Products" output (press the Copy Info button).

And let me know which services show up in SQL Server Configuration Manager.

And the output from SELECT @@VERSION would also assist.

Thanks,

Keith.

Apr 6, 2010 at 1:27 PM

Keith,

I verified the dll is in both Pipeline folders, I had to copy it to the other Pipeline folder though.  I restarted BIDS and I still get the error.

Installed Products:

Microsoft Visual Studio 2005
Version 8.0.50727.762  (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727

Installed Edition: IDE Standard

Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service Pack 1 (KB926601)  
This service pack is for Microsoft Visual Studio 2005 Premier Partner Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/926601

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 9.00.3042.00

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 9.00.3042.00

 

Services:
Integration Services, Full Text Search, Analysis Services, Reporting Services, Browser(stopped), Agent, SQL Server

Version:

Microsoft SQL Server 2005 - 9.00.3077.00 (X64)   Dec 17 2008 20:40:08   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Thanks for helping with this.

Jeremy

Coordinator
Apr 7, 2010 at 2:52 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.