Wednesday, March 7, 2012

copy a task error

Have you ever gotten an error when copying a task in the designer? I can't copy a task. That's going to be a pain for developing big packages. I have already uninstalled BIDS and installed Visual Studio and still get the error. Any thoughts on what could I could remove and reinstall to get a working environment? Would removing VS and SQL 2005 and all its components work? I ran some of the CTP cleanup tools (ttool and msiinv) and they reported no problems and no beta software

TITLE: Microsoft Visual Studio

An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects.


ADDITIONAL INFORMATION:

Could not copy object 'info Script 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.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=SerializeComponentsFailed&LinkId=20476

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


BUTTONS:

OK

I posted here the same question in the VS Installation and Setup forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=26&SiteID=1, but I think this forum may be more on target.

The problem was lingering beta code. Which is weird since I looked at CTPs on an older machine and can't remember installing any beta code on this new machine.

I resolved the problem by uninstalling Visual Studio, SQL components and finally SQL 2005. I ran cleanup tools, ttool.exe, vs_uninst.exe, vs_uninst_betas.exe, and vs2005_beta_cleanup_tool, and it was vs_uninst_betas.exe that did the job.

Next time, I'll only run the CTP on a virtual machine. Heck, CTPs/betas should be released in virtual PC or VMware. Then testers will just need a vm player.

No comments:

Post a Comment