Script task edit on visual studio 2008 Integration Services project fails

• ForumUser3

  Default port

  Points: 1415

  More actions

  January 24, 2014 at 5:51 am

  #303349

  I installed BIDS from SQL Server 2008 R2 installer. I have .Net Framework 3.5 SP1 and sql server 2008 R2 with SP2.

  I also have BIDS 2010 and sql 2012 installed on the same machine, which is working fine.

  I created a new SSIS project on Visual Studio 2008 and added a script task to the control flow. I added User::test in the read only variables list. When I click on edit script I get the error copied below. The MSDN forum (http://blogs.msdn.com/b/jason_howell/archive/2010/08/18/vsta-setup-and-configuration-troubles-for-ssis-2008-and-r2-installations.aspx) suggested to uninstall and re install SQL Server 2008 to fix this problem, which I did, but it did not fix the problem. What needs to be done to fix this problem?

  Is there a way Microsoft tech support can check my installation via webex to help fix it?

  Error:

  "

  Error: TITLE: Microsoft Visual Studio

  ------------------------------

  Cannot show Visual Studio 2008 Tools for Applications editor.

  ------------------------------

  ADDITIONAL INFORMATION:

  The VSTA designer failed to load: "System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

  at VSTADTEProvider.Interop.VSTADTEProviderClass.GetDTE(String bstrHostID, UInt32 dwTimeout)

  at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()" (Microsoft.SqlServer.VSTAScriptingLib)

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  "

  Thanks for your help.

  Forum User:cool: