Error reporting from SP to .NET code, how?

Hey

ASP.NET 2.0 + MS Sql Server 2005 Express (that version which comes with VS2005)

This code below fails. The Delete method executes a stored procedure, but somehow this SP fails. The SP shown here is a short version of the actual SP. As you see from the code below, there are no way the Delete method can know if SP executed successfully. I assume I just could have returned @.@.error, but that just gives an error number, and not the description of the error??.. And how should I capture exceptions like these?? How should code this SP so it report the error??

Any suggestions??

public override void Delete(System.Guid id, int user)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("SendMessage", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@.id", SqlDbType.UniqueIdentifier).Value = id;
cmd.Parameters.Add("@.user", SqlDbType.Int).Value = user;
}
}

ALTER PROCEDURE dbo.DeleteMessage @.id uniqueidentifier, @.user int
AS
BEGIN
UPDATE table_A set column_A = 1 WHERE Id = @.id;
DELETE FROM table_B WHERE Id = @.id;
IF (@.@.error = 0)
COMMIT TRAN;
ELSE
ROLLBACK TRAN;
END

there is a couple of way to report that what happened, you can use execute nonquery to get number of rows affected by last SQL command, you can return from your procedure single cell using SELECT with value 0 for success and 1 for error and finally you can use output parameters and read its values after procedure executes. See T-SQL help in SQL management studio express which is very good and you can find everything you wont.

Error 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 xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
Marcus
I just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus
|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
[vbcol=seagreen]
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus
|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
[vbcol=seagreen]
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus
|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus

Error 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 xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
MarcusI just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
>>sigh<<
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
>>sigh<<
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||I just reinstalled SQL Server and applied the most recent service
pack. Still no go. Anyone?
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||On Mon, 20 Aug 2007 22:13:29 -0000, Marcus <holysmokes99@.hotmail.com>
wrote:
>I just reinstalled SQL Server and applied the most recent service
>pack. Still no go. Anyone?
>Marcus
I suggest asking in microsoft.public.sqlserver.integrationsvcs, rather
than in the .server group.
Roy Harvey
Beacon Falls, CT

Error 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 xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
MarcusI just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).

Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:[vbcol=seagreen]
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).

Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:[vbcol=seagreen]
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> 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 xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus