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
Showing posts with label anerror. Show all posts
Showing posts with label anerror. Show all posts
Monday, March 19, 2012
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
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
Friday, February 24, 2012
Error Message on optimization plan in sqlserver 2000
I am not a SQL Server DBA but trying to figure this out,
The 'OptimizationsJob For Db Maintenance Plan' is failing with an
error -- When I checked the error message the index rebuild is failing
for one of the tables with an error of
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC SQL Server Driver][SQL Server]DBCC failed because the following
SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
This table "t" exists in both our Dev and Prod Servers but I see this
issue only in the Prod server (the prod server has more data)...
I ran this query:
select * from sysobjects where type = 'V'
and objectproperty(id, 'IsIndexed') = 1
for any indexed views and returns null
What are my options?
TIA,
Mag
What about computed columns. If memory serves me, it is enough to have statistics on a computed
column for this error to happen.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message news:1175025577.736504.80620@.b75g2000hsg.googlegro ups.com...
>I am not a SQL Server DBA but trying to figure this out,
> The 'OptimizationsJob For Db Maintenance Plan' is failing with an
> error -- When I checked the error message the index rebuild is failing
> for one of the tables with an error of
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
> [ODBC SQL Server Driver][SQL Server]DBCC failed because the following
> SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
>
> This table "t" exists in both our Dev and Prod Servers but I see this
> issue only in the Prod server (the prod server has more data)...
> I ran this query:
> select * from sysobjects where type = 'V'
> and objectproperty(id, 'IsIndexed') = 1
> for any indexed views and returns null
>
> What are my options?
>
> TIA,
> Mag
>
|||On Mar 27, 3:09 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> What about computed columns. If memory serves me, it is enough to have statistics on a computed
> column for this error to happen.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
>
> <aspirin...@.gmail.com> wrote in messagenews:1175025577.736504.80620@.b75g2000hsg.go oglegroups.com...
>
>
>
>
> - Show quoted text -
There is no computed columns on this table and how come the DEV/Test
instance is not showing the same exception...
|||> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
That could have been because auto-statistics could have been created on the dev server but not the
prod server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message
news:1175029664.750939.316180@.p77g2000hsh.googlegr oups.com...
> On Mar 27, 3:09 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
>
The 'OptimizationsJob For Db Maintenance Plan' is failing with an
error -- When I checked the error message the index rebuild is failing
for one of the tables with an error of
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC SQL Server Driver][SQL Server]DBCC failed because the following
SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
This table "t" exists in both our Dev and Prod Servers but I see this
issue only in the Prod server (the prod server has more data)...
I ran this query:
select * from sysobjects where type = 'V'
and objectproperty(id, 'IsIndexed') = 1
for any indexed views and returns null
What are my options?
TIA,
Mag
What about computed columns. If memory serves me, it is enough to have statistics on a computed
column for this error to happen.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message news:1175025577.736504.80620@.b75g2000hsg.googlegro ups.com...
>I am not a SQL Server DBA but trying to figure this out,
> The 'OptimizationsJob For Db Maintenance Plan' is failing with an
> error -- When I checked the error message the index rebuild is failing
> for one of the tables with an error of
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
> [ODBC SQL Server Driver][SQL Server]DBCC failed because the following
> SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
>
> This table "t" exists in both our Dev and Prod Servers but I see this
> issue only in the Prod server (the prod server has more data)...
> I ran this query:
> select * from sysobjects where type = 'V'
> and objectproperty(id, 'IsIndexed') = 1
> for any indexed views and returns null
>
> What are my options?
>
> TIA,
> Mag
>
|||On Mar 27, 3:09 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> What about computed columns. If memory serves me, it is enough to have statistics on a computed
> column for this error to happen.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
>
> <aspirin...@.gmail.com> wrote in messagenews:1175025577.736504.80620@.b75g2000hsg.go oglegroups.com...
>
>
>
>
> - Show quoted text -
There is no computed columns on this table and how come the DEV/Test
instance is not showing the same exception...
|||> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
That could have been because auto-statistics could have been created on the dev server but not the
prod server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message
news:1175029664.750939.316180@.p77g2000hsh.googlegr oups.com...
> On Mar 27, 3:09 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
>
Error Message on optimization plan in sqlserver 2000
I am not a SQL Server DBA but trying to figure this out,
The 'OptimizationsJob For Db Maintenance Plan' is failing with an
error -- When I checked the error message the index rebuild is failing
for one of the tables with an error of
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC SQL Server Driver][SQL Server]DBCC failed because the followin
g
SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
This table "t" exists in both our Dev and Prod Servers but I see this
issue only in the Prod server (the prod server has more data)...
I ran this query:
select * from sysobjects where type = 'V'
and objectproperty(id, 'IsIndexed') = 1
for any indexed views and returns null
What are my options?
TIA,
MagWhat about computed columns. If memory serves me, it is enough to have stati
stics on a computed
column for this error to happen.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message news:1175025577.736504.80620@.b75g2000hsg.googlegroup
s.com...
>I am not a SQL Server DBA but trying to figure this out,
> The 'OptimizationsJob For Db Maintenance Plan' is failing with an
> error -- When I checked the error message the index rebuild is failing
> for one of the tables with an error of
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
> [ODBC SQL Server Driver][SQL Server]DBCC failed because the follow
ing
> SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
>
> This table "t" exists in both our Dev and Prod Servers but I see this
> issue only in the Prod server (the prod server has more data)...
> I ran this query:
> select * from sysobjects where type = 'V'
> and objectproperty(id, 'IsIndexed') = 1
> for any indexed views and returns null
>
> What are my options?
>
> TIA,
> Mag
>|||On Mar 27, 3:09 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> What about computed columns. If memory serves me, it is enough to have sta
tistics on a computed
> column for this error to happen.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://www.solidqualitylearning.com/
>
> <aspirin...@.gmail.com> wrote in messagenews:1175025577.736504.80620@.b75g20
00hsg.googlegroups.com...
>
>
>
>
>
>
>
>
> - Show quoted text -
There is no computed columns on this table and how come the DEV/Test
instance is not showing the same exception...|||> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
That could have been because auto-statistics could have been created on the
dev server but not the
prod server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message
news:1175029664.750939.316180@.p77g2000hsh.googlegroups.com...
> On Mar 27, 3:09 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
>
The 'OptimizationsJob For Db Maintenance Plan' is failing with an
error -- When I checked the error message the index rebuild is failing
for one of the tables with an error of
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC SQL Server Driver][SQL Server]DBCC failed because the followin
g
SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
This table "t" exists in both our Dev and Prod Servers but I see this
issue only in the Prod server (the prod server has more data)...
I ran this query:
select * from sysobjects where type = 'V'
and objectproperty(id, 'IsIndexed') = 1
for any indexed views and returns null
What are my options?
TIA,
MagWhat about computed columns. If memory serves me, it is enough to have stati
stics on a computed
column for this error to happen.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message news:1175025577.736504.80620@.b75g2000hsg.googlegroup
s.com...
>I am not a SQL Server DBA but trying to figure this out,
> The 'OptimizationsJob For Db Maintenance Plan' is failing with an
> error -- When I checked the error message the index rebuild is failing
> for one of the tables with an error of
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
> [ODBC SQL Server Driver][SQL Server]DBCC failed because the follow
ing
> SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
>
> This table "t" exists in both our Dev and Prod Servers but I see this
> issue only in the Prod server (the prod server has more data)...
> I ran this query:
> select * from sysobjects where type = 'V'
> and objectproperty(id, 'IsIndexed') = 1
> for any indexed views and returns null
>
> What are my options?
>
> TIA,
> Mag
>|||On Mar 27, 3:09 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> What about computed columns. If memory serves me, it is enough to have sta
tistics on a computed
> column for this error to happen.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://www.solidqualitylearning.com/
>
> <aspirin...@.gmail.com> wrote in messagenews:1175025577.736504.80620@.b75g20
00hsg.googlegroups.com...
>
>
>
>
>
>
>
>
> - Show quoted text -
There is no computed columns on this table and how come the DEV/Test
instance is not showing the same exception...|||> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
That could have been because auto-statistics could have been created on the
dev server but not the
prod server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<aspiring22@.gmail.com> wrote in message
news:1175029664.750939.316180@.p77g2000hsh.googlegroups.com...
> On Mar 27, 3:09 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no computed columns on this table and how come the DEV/Test
> instance is not showing the same exception...
>
Subscribe to:
Posts (Atom)