I am getting the following error in SQL Server 2008 R2 (build 10.50.1734) x86 platform BI Development Studio (BIDS) 9.0.30729.4462 with .NET Framework 3.5 SP1 in a Integration Services project.
I have a package with a Data Flow task that contains a Script Component. I edit it and attempt to edit script and I get the following error:
Registration information for this application needs to be updated. To update, log on as an administrator and run this command:
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\VSTA.exe /HostID SSIS_ScriptComponent /setup
About a minute later, another box displays with the following message
Cannot show Visual Studio Tools for Applications editor.
The VSTA designer failed to load. “System.Runtime.InteropServices.COMExeption (0x80004005) Error HRESULT E_FAIL has been returned from a call to a COM component at VSTADTAProvider.Interop.VSTADTEProiderClass.GetDTE(String bysHostID, Uint32 dwTimeout).
I execute the command above running as an administrator (there are no output results). BIDS displays the same symptoms.
This happens on a Windows 7 Enterprise (I said Professional in an earlier but un-related post) workstation x86 platform. I get the error even if I create a new script component in a new data flow task in a new package. I also have VS 2010 Premium
Edition (build 10.0.30319.1 RTMRel) i
View Complete Post