Microsoft Visual Studio is unable to load this document: Object reference is not set to an instance of an object
Hi Everyone,
Please help me on this issue. I'm a new SSIS User.
I've installed Sql Server 2005 Developer Edition
When I create a new SSIS Project in Business Intelligence Development Studio,
I get the following message:
"Microsoft Visual Studio is unable to load this document: Object reference is not set to an instance of an object".
Error loading 'package.dtsx'bject reference is not set to an instance of an object
When I try to debug the package, I get the below message:
parameter Component(System.Design) is null.
I've uninstalled and installed SS 2005 several times, yet the problem persists.
Please help.
This is the package.dtsx
<?xml version="1.0"?><DTS:Executable xmlnsTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTSroperty DTS:Name="PackageFormatVersion">2</DTSroperty><DTSroperty DTS:Name="VersionComments"></DTSroperty><DTSroperty DTS:Name="CreatorName">US\kothand1</DTSroperty><DTSroperty DTS:Name="CreatorComputerName">US6051KOTHAND1</DTSroperty><DTSroperty DTS:Name="CreationDate" DTSataType="7">4/8/2008 10:53:39 AM</DTSroperty><DTSroperty DTS:Name="PackageType">5</DTSroperty><DTSroperty DTS:Name="ProtectionLevel">1</DTSroperty><DTSroperty DTS:Name="MaxConcurrentExecutables">-1</DTSroperty><DTSroperty DTS:Name="PackagePriorityClass">0</DTSroperty><DTSroperty DTS:Name="VersionMajor">1</DTSroperty><DTSroperty DTS:Name="VersionMinor">0</DTSroperty><DTSroperty DTS:Name="VersionBuild">0</DTSroperty><DTSroperty DTS:Name="VersionGUID">{FBD98635-EDDE-4F58-9D53-356E8CB653FB}</DTSroperty><DTSroperty DTS:Name="EnableConfig">0</DTSroperty><DTSroperty DTS:Name="CheckpointFileName"></DTSroperty><DTSroperty DTS:Name="SaveCheckpoints">0</DTSroperty><DTSroperty DTS:Name="CheckpointUsage">0</DTSroperty><DTSroperty DTS:Name="SuppressConfigurationWarnings">0</DTSroperty><DTSroperty DTS:Name="ForceExecValue">0</DTSroperty><DTSroperty DTS:Name="ExecValue" DTSataType="3">0</DTSroperty><DTSroperty DTS:Name="ForceExecutionResult">-1</DTSroperty><DTSroperty DTS:Name="Disabled">0</DTSroperty><DTSroperty DTS:Name="FailPackageOnFailure">0</DTSroperty><DTSroperty DTS:Name="FailParentOnFailure">0</DTSroperty><DTSroperty DTS:Name="MaxErrorCount">1</DTSroperty><DTSroperty DTS:Name="ISOLevel">1048576</DTSroperty><DTSroperty DTS:Name="LocaleID">1033</DTSroperty><DTSroperty DTS:Name="TransactionOption">1</DTSroperty><DTSroperty DTS:Name="DelayValidation">0</DTSroperty>
<DTS:LoggingOptions><DTSroperty DTS:Name="LoggingMode">0</DTSroperty><DTSroperty DTS:Name="FilterKind">1</DTSroperty><DTSroperty DTS:Name="EventFilter" DTSataType="8"></DTSroperty></DTS:LoggingOptions><DTSroperty DTS:Name="ObjectName">Package</DTSroperty><DTSroperty DTS:Name="DTSID">{191D188C-EA6E-46D6-A46A-8C9F3C21C321}</DTSroperty><DTSroperty DTS:Name="Description"></DTSroperty><DTSroperty DTS:Name="CreationName">MSDTS.Package.1</DTSroperty><DTSroperty DTS:Name="DisableEventHandlers">0</DTSroperty></DTS:Executable>
Thanks
Best Regards
April 8th, 2008 5:56pm
What is your HW & SW platform?
Did you install SQL Server 2005 SP2?
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2008 6:00pm
What is your HW & SW platform?
Did you install SQL Server 2005 SP2?
April 8th, 2008 6:00pm
What is your HW & SW platform?
Did you install SQL Server 2005 SP2?
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2008 6:00pm
No I have not yet. I've applied just the windows updates. I rebooted after the updates, but the problem persists.
I evern tried importing the .vssettings file from my co-worker's. Also, I tried resetting the user settings
using "%programfiles%\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" /resetuserdata.
I'm on Windows xp 2002 service pack 2.Sql server 2005 Developer edition.
Visual Studio info:
Microsoft Visual Studio 2005Version 8.0.50727.762 (SP.050727-7600)Microsoft .NET FrameworkVersion 2.0.50727 SP1
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.1399.00
SQL Server Integration Services Microsoft SQL Server Integration Services DesignerVersion 9.00.1399.00
SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 9.00.1399.00
Thanks
Best regards
April 8th, 2008 8:10pm
May I suggest that you don't do anything until SP2 is installed?
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2008 8:58pm
May I suggest that you don't do anything until SP2 is installed?
April 8th, 2008 8:58pm
May I suggest that you don't do anything until SP2 is installed?
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2008 8:58pm
Hi ,
I have installed the SP2 but I'm getting the error still.
Has any had this error. If so please let me know how resolved this.
For some reason, my BIDS is not able to open the Designer.
As I mentioned before, there seems to be some error with System.Design.
Thanks
Regards
April 9th, 2008 12:51am
Hi, I too have been having the same problem. Does anyone out there know a resolution to this? Thanks.
Mike
Free Windows Admin Tool Kit Click here and download it now
April 24th, 2008 6:13pm
Could you try to run these two commands and see if it helps:
regsvr32 msxml3.dll
regsvr32 msxml6.dll
HTH,
Bob
April 30th, 2008 8:16am
regsvr32 msxml3.dll
regsvr32 msxml6.dll
It worked for me. Thanks Bob.
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2008 8:10pm
Hi experts,
I've got the same problem than the one described in the first post, I've try everything described here but i'm still getting this error...
I'm using VS 2005 SP1 and SQL Server 2005 developper with sp2.
regsvr32 msxml3.dll and regsvr32 msxml6.dll commands doesn't work for me :-/
Yet Visual studio seems to be able to manage SSIS packages because SSIS options are visible in solution explorer
Please, I really need help...
Florent MEREL
MCTS: SQL Server 2005 Business Intelligence
Please mark correct answers ;-)
May 12th, 2010 11:33am
I found the solution using:
regsvr32 oleaut32.dll
regsvr32 actxprxy.dll
Regards
Florent
MEREL
MCTS: SQL Server 2005 Business Intelligence
Please mark correct answers ;-)
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2010 11:04am
Florents solution fixed the identical problem for me in both VS2005 and VS2008. Many thanks
December 10th, 2010 5:37am
Excellent Florent Merel, for me worked very nice Thanks!!!Aquellos Que No Conocen El Dolor Jamas Conoceran La Verdadera Paz
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2011 8:38pm