Friday, February 17, 2012

Error immediately on creating new Integration Services project in VS2005

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:

<?xml version="1.0"?><DTS:Executable xmlnsBig SmileTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTSStick out tongueroperty
DTS:Name="PackageFormatVersion">2</DTSStick out tongueroperty><DTSStick out tongueroperty
DTS:Name="VersionComments"></DTSStick out tongueroperty><DTSStick out tongueroperty
DTS:Name="CreatorName">BNHO1\mbell</DTSStick out tongueroperty><DTSStick out tongueroperty
DTS:Name="CreatorComputerName">BT4WKS1361</DTSStick out tongueroperty><DTSStick out tongueroperty
DTS:Name="CreationDate" DTSBig SmileataType="7">8/14/2007 12:22:35 PM</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="PackageType">5</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ProtectionLevel">1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="MaxConcurrentExecutables">-1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="PackagePriorityClass">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionMajor">1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionMinor">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionBuild">0</
DTSStick out tongueroperty><DTSStick out tongueroperty
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="EnableConfig">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CheckpointFileName"></
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="SaveCheckpoints">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CheckpointUsage">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="SuppressConfigurationWarnings">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ForceExecValue">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ExecValue" DTSBig SmileataType="3">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ForceExecutionResult">-1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Disabled">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FailPackageOnFailure">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FailParentOnFailure">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="MaxErrorCount">1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ISOLevel">1048576</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="LocaleID">4105</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="TransactionOption">1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DelayValidation">0</DTSStick out tongueroperty>
<DTS:LoggingOptions><DTSStick out tongueroperty DTS:Name="LoggingMode">0</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FilterKind">1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="EventFilter" DTSBig SmileataType="8"></
DTSStick out tongueroperty></DTS:LoggingOptions><DTSStick out tongueroperty
DTS:Name="ObjectName">Package</DTSStick out tongueroperty><DTSStick out tongueroperty
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Description"></
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreationName">MSDTS.Package.1</
DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DisableEventHandlers">0</
DTSStick out tongueroperty></DTS:Executable>

I have VS2005 SP1, running WindowsXP SP2. Integration Services is
running on my machine, but I would think that this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use. If I take this xml file with the error and copy it to another new SSIS project on another machine, it works fine. Reinstalling VS2005 had no effect. I am now reinstalling SQL Server 2005 SP2 to see what effect that may have.

Any ideas?

Thanks,
MarcusTry searching, but in the mean time:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1627891&SiteID=1|||Thanks for the link. I have seen that one, and I tried re-registering the xml dlls, but that didn't do anything. Hopefully after my reinstall of Sql Server things will be better.

Marcus
|||

Well that was disappointing. After the SQL Server reinstall and adding SP2 there is no change with my problem. >>HEAVY SIGH!<<. I think it is time to call MS...unless any other ideas?!?!?!?

Marcus

|||

Anybody?

M.

No comments:

Post a Comment