"could not serialize the SSIS runtime objects" when attempting to copy tasks created by SSIS wizard

Question

Run the SSIS import/export wizard.

(xls -> sql table)

Select the tasks created.

Copy.

 

Here is the error that occurs.

 

p.s. Does anyone have any needles I can borrow? I think sticking them in my eyes would be nicer than working with SSIS.

 

 

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

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

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

Could not copy object 'Preparation SQL Task' 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)

 

Answer 1

this is the message when you click on the "help" link. ha ha ha ha ha ha ha

 

 

We're sorry

There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time       "at this time"  at this 'kin time? well when it is convenient, please feel free to add some text so I can go about my work as normal.   Thanks.

 

 

Answer 2

Register the xml parser dlls with the below commands.

 

regsvr32.exe msxml3.dll
 regsvr32.exe msxml6.dll

 

 

Answer 3

ok that solves the "copy" problem

 

now when I paste I get the wonderful

 

"microsoft visual studio has encountered an internal error" ..." may be unstable" (may be? may be? !!)

 

upon sending the error, the following error is visible

 

[p.s. don't bother clicking the link as it comes back with the ever useful "we're sorry..." message]

 

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

The designer could not paste one or more executables. (Microsoft Visual Studio)

------------------------------
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=PasteComponentsFailureCause_couldNotRestoreExecutables&LinkId=20476

------------------------------
Program Location:

   at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.PasteComponentsInternal(IDesignerHost host, DesignerTransaction trans, IDataObject dataObj)
   at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.PasteComponents(IDesignerHost host, DesignerTransaction trans, IDataObject dataObj)
   at Microsoft.DataWarehouse.Design.ClipboardCommandHelper.OnMenuPaste(MenuCommand sender, CommandHandlingArgs args)
   at Microsoft.DataWarehouse.Design.CommandHandlingInfoMap.HandleCommand(MenuCommand menuCommand)
   at Microsoft.DataWarehouse.Design.ClipboardCommandHelper.Microsoft.DataWarehouse.Interfaces.ICommandTarget.InvokeCommand(MenuCommand menuCommand)
   at Microsoft.DataWarehouse.Design.ComponentDiagram.InvokeCommand(MenuCommand menuCommand)
   at Microsoft.DataWarehouse.Design.ComponentDiagram.Microsoft.DataWarehouse.Interfaces.ICommandTarget.InvokeCommand(MenuCommand menuCommand)

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

At least one executable could not be pasted correctly.
The executable with the name 'Preparation SQL Task' could not be pasted successfully.
Information about the state of the executable with the name 'Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' could not be loaded from the clipboard.
Exception from HRESULT: 0xC0010028

The executable with the name 'Drop table(s) SQL Task' could not be pasted successfully.
Information about the state of the executable with the name 'Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' could not be loaded from the clipboard.
Exception from HRESULT: 0xC0010028

The executable with the name 'Data Flow Task' could not be pasted successfully.
Information about the state of the executable with the name 'DTS.Pipeline' could not be loaded from the clipboard.
Exception from HRESULT: 0xC0010028 (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=RestoreExecutables_AtLeastOneRestoreExecutableErrorOccured&LinkId=20476

------------------------------
Program Location:

   at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.RestoreExecutables(IDesignerHost host, DesignerTransaction trans, IDTSSequence pasteContainer, XmlNode copiedXml, XmlNamespaceManager nsmgr)
   at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.PasteComponentsInternal(IDesignerHost host, DesignerTransaction trans, IDataObject dataObj)

 

Answer 4

Sounds like a corrupt installation, since registry modification(s) restore functionality. 

 

What OS, architecture (32/64), version OF SQL Server Integration Services (RTM,SP1,SP2,2153 hotfix, post SP2 hotfix, other) is now installed, or purportedly installed?  Is Visual Studio also installed independent of the Visual Studio variant (known colloquially as BIDS)  that installed as part of SSIS? If so, is it RTM or SP1? 

 

Are you able to create packages in BIDS, independent of copy/paste, containing at least one execute sql task, and can those same packages be run from BIDS?  Is this "task copy/paste" issue recent behavior (ie., the copy/paste once worked, and now always fails), or something has been in need of repair from the get-go?

 

 

Answer 5

running BIDS on winxpsp2, 32bit, P4

should be sql server client tools sp2

 

help about vs.net

visual studio 2005 ver. 8.0.50727.762

Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00

 

help about sql mgmt studio

Microsoft SQL Server Management Studio      9.00.3042.00
Microsoft Analysis Services Client Tools      2005.090.3042.00
Microsoft Data Access Components (MDAC)      2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML      2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer      6.0.2900.2180
Microsoft .NET Framework      2.0.50727.42
Operating System      5.1.2600

 

 

I can create, run and we have successfully deployed packages which indeed run on other machines.

 

will a reinstall cure it?

how long will it take?

Answer 6

Try the following as well (which probably won't help, but it won't hurt either)

regsvr32 msxml4.dll

A reinstall would probably fix the issue ("task cut/paste"), however, since you are able to develop and deploy SP2 based packages, perhaps the issue is resolve-able with further dll registrations.

You may wish to search this forum for the term "regsvr32.exe" and attempt further registry additions. Yes, its a fishing expedition, but it may be a shorter one than re-installation. 
I don't know how long a re-install would take.

Answer 7

This has solved the problem for me.

Problem started 2 weeks ago...

Thanks

Philippe

Answer 8

The regsvr32 commands worked for me as well.  Thanks!

Answer 9

Another winner.  Commands worked fine here too.

Thanks for the time saved

Answer 10

One more. Solved!

Thanks.

Answer 11

Register the xml parser dlls with the below commands.

  

regsvr32.exe msxml3.dll
 regsvr32.exe msxml6.dll

 

 

Worked for me too...

Thanks!!!

Answer 12

It works for me as well. Great forum!

---

Sea Cloud

Answer 13

worked like a charm !!  Thanks