Friday, February 24, 2012

Copy(paste) ''serialize'' error always occurs with task, never with components

Some more insight into the error I am getting.

It always occurs at the task (control flow) level and never at the component (data flow) level

It always occurs on the 'copy' action.

I have tried all the msxml/registry recommendations to no avail.

once again here are the error details

===================================

An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. (Microsoft Visual Studio)

===================================

Could not copy object 'SQT Drop Create RAWMigDeal RAWBarrier table' to the clipboard.
(Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=SerializeComponentsFailed&LinkId=20476

Program Location:

at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)
at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.InternalMenuCopy(MenuCommand sender, CommandHandlingArgs args)

===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.PersistImpl.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events)
at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)Does that copy to clipboard error occur each time an attempt is made to copy any Execute SQL task from any SSIS package?|||brand new ssis solution
add a data flow task
right click copy
BANG! same error

here is the package..... (after receiving the error, so not sure what state it is in)
<?xml version="1.0"?><DTS:Executable xmlnsBig SmileTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTSStick out tongueroperty DTS:Name="PackageFormatVersion">2</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionComments"></DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreatorName">CSFB\npearse</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreatorComputerName">XXXXXXXXXXXXX</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreationDate" DTSBig SmileataType="7">8/20/2007 9:52:03 AM</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="PackageType">5</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ProtectionLevel">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="MaxConcurrentExecutables">-1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="PackagePriorityClass">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionMajor">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionMinor">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionBuild">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="VersionGUID">{557D24A8-D190-486E-BD86-A836815DE6DA}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="EnableConfig">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CheckpointFileName"></DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="SaveCheckpoints">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CheckpointUsage">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="SuppressConfigurationWarnings">0</DTSStick out tongueroperty>
<DTSStick out tongueackageVariable><DTSStick out tongueroperty DTS:Name="PackageVariableValue" DTSBig SmileataType="8">&lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsBig Smiledl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsBig Smiledl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlnsBig Smilewd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwdBig SmiletsDataFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="8467" y="7620" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01000000900144420100144d6963726f736f66742053616e73205365726966" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwdBig SmiletsDataFlowDiagram&gt;&lt;/TaskHost&gt;</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Namespace">dts-designer-1.0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ObjectName">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DTSID">{90FA5082-2489-4857-AA8B-B7CC0A62D7C7}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Description"></DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreationName"></DTSStick out tongueroperty></DTSStick out tongueackageVariable>
<DTSStick out tongueackageVariable><DTSStick out tongueroperty DTS:Name="PackageVariableValue" DTSBig SmileataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsBig Smiledl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsBig Smiledl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlnsBig Smilewd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwdBig SmiletsControlFlowDiagram&gt;&lt;dwd:BoundingTop&gt;4128&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="33179" y="18283" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="11695" top="4128" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwdBig SmiletsControlFlowDiagram&gt;&lt;/Package&gt;</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Namespace">dts-designer-1.0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ObjectName">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DTSID">{B505F61E-B095-4522-9FA2-8145F92E7976}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Description"></DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreationName"></DTSStick out tongueroperty></DTSStick out tongueackageVariable><DTSStick out tongueroperty DTS:Name="ForceExecValue">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ExecValue" DTSBig SmileataType="3">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ForceExecutionResult">-1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Disabled">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FailPackageOnFailure">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FailParentOnFailure">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="MaxErrorCount">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ISOLevel">1048576</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="LocaleID">2057</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="TransactionOption">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DelayValidation">0</DTSStick out tongueroperty>
<DTS:LoggingOptions><DTSStick out tongueroperty DTS:Name="LoggingMode">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FilterKind">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="EventFilter" DTSBig SmileataType="8"></DTSStick out tongueroperty></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTSStick out tongueroperty DTS:Name="ExecutionLocation">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ExecutionAddress"></DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="TaskContact">Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ForceExecValue">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ExecValue" DTSBig SmileataType="3">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ForceExecutionResult">-1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Disabled">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FailPackageOnFailure">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FailParentOnFailure">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="MaxErrorCount">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="ISOLevel">1048576</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="LocaleID">-1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="TransactionOption">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DelayValidation">0</DTSStick out tongueroperty>
<DTS:LoggingOptions><DTSStick out tongueroperty DTS:Name="LoggingMode">0</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="FilterKind">1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="EventFilter" DTSBig SmileataType="8"></DTSStick out tongueroperty></DTS:LoggingOptions><DTSStick out tongueroperty DTS:Name="ObjectName">Data Flow Task</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DTSID">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Description">Data Flow Task</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreationName">DTS.Pipeline.1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DisableEventHandlers">0</DTSStick out tongueroperty><DTSSurprisebjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true"/></DTSSurprisebjectData></DTS:Executable><DTSStick out tongueroperty DTS:Name="ObjectName">Package</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DTSID">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="Description"></DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="CreationName">MSDTS.Package.1</DTSStick out tongueroperty><DTSStick out tongueroperty DTS:Name="DisableEventHandlers">0</DTSStick out tongueroperty></DTS:Executable>|||Paste the package xml in a code block, via the Mark Code block button, and you will not get the smilies all over the place.|||

Code Snippet

<?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">CSFB\npearse</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">XXXXXXXXXXXXX</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">8/20/2007 9:52:03 AM</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">1</DTS:Property><DTS:Property DTS:Name="VersionGUID">{557D24A8-D190-486E-BD86-A836815DE6DA}</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:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsDataFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="8467" y="7620" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01000000900144420100144d6963726f736f66742053616e73205365726966" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsDataFlowDiagram&gt;&lt;/TaskHost&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTS:Property><DTS:Property DTS:Name="DTSID">{90FA5082-2489-4857-AA8B-B7CC0A62D7C7}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:BoundingTop&gt;4128&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="4" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="33179" y="18283" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="11695" top="4128" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</DTS:Property><DTS:Property DTS:Name="DTSID">{B505F61E-B095-4522-9FA2-8145F92E7976}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><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">2057</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:Executable DTS:ExecutableType="DTS.Pipeline.1"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</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">-1</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">Data Flow Task</DTS:Property><DTS:Property DTS:Name="DTSID">{1DB3E9F2-E9DA-4CC2-B0BD-B50C68313755}</DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property><DTS:Property DTS:Name="CreationName">DTS.Pipeline.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true"/></DTS:ObjectData></DTS:Executable><DTS:Property DTS:Name="ObjectName">Package</DTS:Property><DTS:Property DTS:Name="DTSID">{7F14B299-8F44-4202-9A3C-6B5D970B5ADA}</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>


|||

At this point, if you've re-installed and this basic operation (clipboard cut/copy) continues to occur, I would see if you can get SSIS working in a VPC (virtual PC 2007 is a free download) with undo disks set to on, so you can just get back to a clean slate if need be.

Now, using the SSIS package xml provided, cut/copy and paste from a Windows Vista x64 OS work fine. There was not, nor has their ever been (on that machine) or any of the approximately 15 different SSIS installs (some Vista, some XP, some Win2k3, some 32 bit, some 64 bit, some VPC), that error. So, all that means the package xml is not the issue.

Now, looking at the dlls and assemblies being pulled in, the following below 2 are prominently used, which you've already re-registered.

msxml3.dll

msxml6.dll

No comments:

Post a Comment