Using BI Studio, attempting to put a small VB script in a Script Task, hitting the Edit Script gives: Cannot show Visual Studio 2008 Tools for Applications editor ADDITIONAL INFORMATION: Could not load file or assembly 'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.VSTAScriptingLib) NEED A FIX, PLEASE, AS I'VE ALREADY LOADED VS2008 SP1...! I have now also uninstalled VS2008 entirely, along with .NET 3.5 SP1 rebooted several times, reinstalled from the January Team System Database Edition, applied VS2008 SP1 and .Net 3.5 SP1 from Microsoft Downloads with the usual reboots to make sure, and I'm still hosed... Microsoft Visual Studio 2008Version 9.0.30729.1 SPMicrosoft .NET FrameworkVersion 3.5 SP1 Installed Edition: Enterprise Microsoft Visual Basic 2008 91901-270-1018792-60217Microsoft Visual Basic 2008 Microsoft Visual C# 2008 91901-270-1018792-60217Microsoft Visual C# 2008 Microsoft Visual C++ 2008 91901-270-1018792-60217Microsoft Visual C++ 2008 Microsoft Visual Studio 2008 Tools for Office 91901-270-1018792-60217Microsoft Visual Studio 2008 Tools for Office Microsoft Visual Studio Team System 2008 Database Edition 91901-270-1018792-60217Microsoft Visual Studio Team System 2008 Database Edition Microsoft Visual Web Developer 2008 91901-270-1018792-60217Microsoft Visual Web Developer 2008 Crystal Reports AAJ60-G0MSA4K-68000CFCrystal Reports Basic for Visual Studio 2008 Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282) KB945282This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/945282. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946040) KB946040This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/946040. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946308) KB946308This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/946308. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946344) KB946344This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/946344. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946581) KB946581This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/946581. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947173) KB947173This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/947173. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947540) KB947540This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/947540. Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947789) KB947789This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/947789. Hotfix for Visual Studio Team System 2008 Database Edition - ENU (KB944899) KB944899This hotfix is for Visual Studio Team System 2008 Database Edition - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/944899. Hotfix for Visual Studio Team System 2008 Database Edition - ENU (KB947171) KB947171This hotfix is for Visual Studio Team System 2008 Database Edition - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/947171. Hotfix for Visual Studio Team System 2008 Database Edition - ENU (KB947180) KB947180This hotfix is for Visual Studio Team System 2008 Database Edition - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/947180. Hotfix for Visual Studio Team System 2008 Database Edition - ENU (KB948127) KB948127This hotfix is for Visual Studio Team System 2008 Database Edition - ENU.If you later install a more recent service pack, this hotfix will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/948127. Liquid Web Service Browser 6.1.18.0Liquid XML Studio 2008 - Web Service Browser Liquid XML Schema Editor 6.1.18.0Liquid XML Studio 2008 - Graphical XML Schema Editor Liquid XPath Expression Builder 6.1.18.0Liquid XML Studio 2008 - XPath Expression Builder Microsoft Web Deployment Projects 2008 00000Microsoft Web Deployment Projects 2008Version 9.0.21022 SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 10.0.1600.22 SQL Server Integration Services Microsoft SQL Server Integration Services DesignerVersion 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 10.0.1600.22 Visual Studio Team System 2008 Database Edition - ENU Service Pack 1 (KB945140) KB945140This service pack is for Visual Studio Team System 2008 Database Edition - ENU.If you later install a more recent service pack, this service pack will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/945140. Visual Studio Team System 2008 Database Edition - ENU Service Pack 1 (KB947888) KB947888This service pack is for Visual Studio Team System 2008 Database Edition - ENU.If you later install a more recent service pack, this service pack will be uninstalled automatically.For more information, visit http://support.microsoft.com/kb/947888. SQL Prompt 3.8For more information about SQL Prompt, see the Red Gate website athttp://www.red-gate.comFor customer support, call 1-866-733-4283.Copyright 20062008 Red Gate Software Ltd

After lodging a CASE with MS, the answer is: Uninstall back to pre-SQL Server 2008, and pre-.Net 3.5 (including SP1), and pre-VS2008, rebooting as you go.. Go back to Control Panel ==> Add/Remove Programs AND WHACK THE STUFF THAT THE UNINSTALLS LEAVE BEHIND FROM SS AND VS! Tons of it - rubbish uninstaller!!! Took an hour to get rid of the remnants - stunned! Run a REGISTRY CLEANER! Install SQL Server 2008. Reboot. Install .Net 3.5. Reboot. Install VS 2008 Database Edition (January 2008 version). Reboot. Check for the presence of c:\Windows\assembly\VSTADTEProvider.Interop REPAIR .Net 3.5. Download and install/Repair the .Net 3.5 REDISTRIBUTABLE - VERY IMPORTANT (just talked to Microsoft and that's THEIR advice). Install .Net 3.5 SP1. Reboot. Install VS2008 SP1. Check the assembly above is still there... Reboot! Run BIS 2008 and create a new Project with a Script Task and "Edit Script" - should work... BTW: there is a VS2008 uninstall tool on MSDN site accoring to MSat msdn.microsoft.com/en-us/vs2008/bb968856.aspx

Could you specify what REGISTRY CLEANER to use? I have the same problem with VSTA :(

I'm getting the same exact error upon trying to edit a Script Task in SSIS. Isit really necessary tore-install everything to resolve this bug!?

That is the only thing that helped me. I had a slightly different error message though - it could find the dll, but then dll itslef returned a COM error (see below). I also had it installed on a D: drive, now it's on C:. It seems to be a problem with VSTA registration with VisStudio and SSIS editor, and VSTA is apparently a separate application. You can try reinstalling VSTA, or locating that DLL and making sure it's properly set in the registry (good luck with that :) I used .Net framework removal tool, too, to clean stuff. TITLE:MicrosoftVisualStudio ------------------------------ CannotshowVisualStudio2008ToolsforApplicationseditor. ------------------------------ ADDITIONALINFORMATION: TheVSTAdesignerfailedtoload:"System.Runtime.InteropServices.COMException(0x80004005):ErrorHRESULTE_FAILhasbeenreturnedfromacalltoaCOMcomponent. atVSTADTEProvider.Interop.VSTADTEProviderClass.GetDTE(StringbstrHostID,UInt32dwTimeout) atMicrosoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()"(Microsoft.SqlServer.VSTAScriptingLib) ------------------------------ BUTTONS: OK ------------------------------ =================================== CannotshowVisualStudio2008ToolsforApplicationseditor.(MicrosoftVisualStudio) =================================== TheVSTAdesignerfailedtoload:"System.Runtime.InteropServices.COMException(0x80004005):ErrorHRESULTE_FAILhasbeenreturnedfromacalltoaCOMcomponent. atVSTADTEProvider.Interop.VSTADTEProviderClass.GetDTE(StringbstrHostID,UInt32dwTimeout) atMicrosoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()"(Microsoft.SqlServer.VSTAScriptingLib) ------------------------------ ProgramLocation: atMicrosoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject() atMicrosoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(StringlanguageID,Stringprojectname,Stringprojectext,BooleanbCleanupOnClose) atMicrosoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(StringlanguageID,Stringprojectname,Stringprojectext) atMicrosoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.ShowIDE()

I'm getting a different error that seems to be related to compatibility with 2005 and 2008 since the script was created in 2005. The odd thing is that it runs and I was able to edit it until I re-installed VS2009 and .NET 3.5. I've tried re-installing VS2008 and .NET 3.5 again to no avail! ================================== Cannot show Visual Studio 2008 Tools for Applications editor. (Microsoft Visual Studio) =================================== Could not load file or assembly 'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.VSTAScriptingLib) ------------------------------Program Location: at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject() at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.LoadScriptFromStorage() at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.ShowIDE()

Hi All, I managed to sort it out by uninstalling just Microsoft VSTA 2.0 under Add\remove programs and then running a repair on my SQL 2008 installation. No need for all the steps listed above. Regards Chris

I had the same problem. After uninstalling and reinstalling Visual Studio 2008, SQL Server 2008, .NET Framework 3.5 and SP1 several times with different options, the problem was still there. I found out that the source of the problem was a previous installation of Visual Studio 2008 on a different disk. The OS is Vista x64 I solved it by examining the Visual Studio activity using Process Explorer: I found out that visual studio was trying to access several files on the wrong disk. The files referred to were inside D:\Program Files (x86)\Microsoft Visual Studio 9.0\ ... My current visual studio folder was C:\Program Files (x86)\Microsoft Visual Studio 9.0\... Examining the registry access right above the wrong disk access I found 2 registry keys with several values referring to the wrong disk. Using regedit I saved all the tree of the keys of the registry and did a search of the wrong path and replace with the correct one. The problem was solved. The keys are: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VSTAHost\SSIS_ScriptComponent] and [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VSTAHost\SSIS_ScriptTask\9.0]

Better solution, go tohttp://www.summsoft.com/VSTAInfReq.aspxDownload the VSTA 2.0 SDK and install. This will resolve your issue without reinstalling SQL or VS 2008.Note, I'm posting this here sothat people using google and bing searches might find this answer without wasting a hour like I did.

Uninstalling from Add or Remove Programs and then repairing the SQL Server installlation worked for me too. I had the same error message as above, containing EnsureDTEObject.

Hello!I had also "TheVSTAdesignerfailedtoload:"System.Runtime.InteropServices.COMException(0x80004005):ErrorHRESULT"The reason was wrong default impersonation level in computer settings (My computer properties). I changed tifrom"Anonymous" to "Identify" and it VSTA started to work.Cazzy Cape

I had a Cannot show Visual Studio 2008 Tools for Applications editor error when clicking Edit Script to add a VB2008 script to a script task in BI 2008 too.It was solved by adding another script task to the package and clicking Edit Script to add a C#2008 script. This brought up VS just fine.I closed the VS C# editor...Then when I went back to the previous script task to edit the VB script, it worked... no uninstall, patching, etc. was necessary.

I haven't researched this much as of yet, but I experience this issue - I found that if run VS in administrator mode, then it works fine. >>right click on application icon >>select 'Run as Administrator' assuming you have these permissions...this might help.

This didn't work for me. I'm trying to repair a 2008 R2 installation.Data Architect and Database Consultant Medford, Oregon

This didn't work either.Data Architect and Database Consultant Medford, Oregon

Stuff worked the way it was stated by AviationPlanning. There is no need for any other steps. Thank you.

I initially tried uninstalling SQLserver 2008 R2 and Visual Studio 2008, doing a registry cleanup and then reinstaling. This failed, but I may have missed uninstalling VSTA. Uninstalling that and doing a repair fixed the problem for me too. This would have saved me nearly a day if I'd know to try that first!

The "solution" put forward by Rob Buttenhoff worked for me!

I have wasted more than a day to fix this problem. I uninstalled SQL server 2008 , installed VS 2008 SP1 and installed SQL server 2008 again and same issue again. I am highly frustated. Can someone suggest me how to fix this error. THis link http://summsoft.com/VSTAInfReq.aspx doesnt have download option enabled. Please help !!!!! Thanks, Swati Cannot show Visual Studio 2008 Tools for Applications editor ADDITIONAL INFORMATION: Could not load file or assembly 'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.VSTAScriptingLib)

I resolved this problem by going to Control Panel/Add Remove Programs and removing Microsoft Visual Studio Tools for Applications 2.0 (VSTA) and then repairing the 'shared features' of the SQL Server 2008. My version of Microsoft.SqlServer.VSTAScriptingLib.dll is 10 but VSTA is still looking for version 9.0.0.0

I've tried this and it's working fine for me. Short and sweet. Thanks.

My error was 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) I have VS & SQL 2005/8 all installed at different times so this could be the cause of the problem. Thankfully simply launching the reinstall program from the SQL Disc cured the problem (..\Enterprise\x86\Setup\trin_aide.msi). I suppose that you could use the Control Panel to Remove and then re-install. Good luck. Preet