Hi All,I was wondering if someone would be kind enough to assist me with the following issue?Using Visual Studio 2008 and editing an SSIS project.Using a data flow task, create a script component, when I attempt to edit the script I get the following errorCannotshow Visual Studio Tools for Applications EditorAdditional Information:The System Cannot Find The File Specified (Exception from HRESULT: 0x80070002) (EnvDTE80)I've gone through the following articlehttp://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=367845with no success andI alsoreinstalled SQL Server 2008 and VS 2008 still with no successRunning on Windows XP SP 2SQL Server 2008 SP 1VS 2008 SP 1Any ideas would be greatly appreciatedRegardsJohn

hi,are you getting the error while editing OR clicking on design script button?which edition of sql server you are using ( enterprise, develpoer....)thanks-Let us TRY this | Dont forget to mark the post(s) that answered your question

Hi I get the issue when I click on the edit button under script. I'm using developer editionRegardsJohn

I am also having the same problem. Tried uninstalling 2008 SQL server, Visual studio 2008, SQl server 2005 and Visual Studio 2008. Visual Studio tools for Applications and reinstalling them.

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.

I installed vsta, sql server 2008 sp1, even reinstalled sql server2008, but the problem still persist .... Can anybody solve thissss thanks in advance

Same issue: Cannotshow Visual Studio Tools for Applications Editor Additional Information: The System Cannot Find The File Specified (Exception from HRESULT: 0x80070002) (EnvDTE80) Unistalled SQL Server Uninstalled just the shared components Installed VSTA 2.0 SDK Repaired VS 2008 Repaired SQL 2008 serveral times Running Vista Ult 64bit Must I tell my client we simply cannot use SSIS in 2008 and that they should consider other options for upgrading their 100s of DTS packages? A re-write to a different solution?

Hi, Please check the following threads on same forum Error Starting Script Editor in SSIS Thanks-Let us TRY this | Dont forget to mark the post(s) that answered your question

Hi, I'm sorry to say that I already tried complete things in mentioned post, before setting a query in this post.... Does anybody got solution... i tried all things like installing r deinstalling sql suite and vsta, registering dlls etc.... any help would be appriciated... thanks in advance

I've used the following command script to clean upcachedVSTA configurations for SSIS with success. From a command prompt (under WoW32 on 64 bit platforms)with admin privileges (make sure to run the command promptas an administrator if you have UAC enabled)run a batch file with the following content:@rem start batch file@rem delete the VSTA registrycache from the current userREG DELETE HKCU\Software\Microsoft\VSTA /fREG DELETE HKCU\Software\Microsoft\VSTAHost\SSIS_ScriptTask /fREG DELETE HKCU\Software\Microsoft\VSTAHost\SSIS_ScriptComponent /f@rem delete the VSTA registration cache for SSIS script task and data flow script componentREG DELETE HKLM\Software\Microsoft\VSTAHost\SSIS_ScriptTask /fREG DELETE HKLM\Software\Microsoft\VSTAHost\SSIS_ScriptComponent /f@rem delete the cached files from the HDDrd /s /q "%AppData%\Microsoft\VSTA"rd /s /q "%AppData%\Microsoft\VSTAHost\SSIS_ScriptTask"rd /s /q "%AppData%\Microsoft\VSTAHost\SSIS_ScriptComponent"rd /s /q "%USERPROFILE%\Local Settings\Application Data\VSTA"rd /s /q "%USERPROFILE%\Local Settings\Application Data\VSTAHost\SSIS_ScriptTask"rd /s /q "%USERPROFILE%\Local Settings\Application Data\VSTAHost\SSIS_ScriptComponent"@rem re-generate the VSTA files for SSIS script task and component"%ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe" /hostid SSIS_ScriptTask /setup"%ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe" /hostid SSIS_ScriptComponent /setup@rem end batch fileHope it helps, This posting is provided "AS IS" with no warranties, and confers no rights

I've used the following command script to clean upcachedVSTA configurations for SSIS with success. From a command prompt (under WoW32 on 64 bit platforms)with admin privileges (make sure to run the command promptas an administrator if you have UAC enabled)run a batch file with the following content:@rem start batch file@rem delete the VSTA registrycache from the current userREG DELETE HKCU\Software\Microsoft\VSTA /fREG DELETE HKCU\Software\Microsoft\VSTAHost\SSIS_ScriptTask /fREG DELETE HKCU\Software\Microsoft\VSTAHost\SSIS_ScriptComponent /f@rem delete the VSTA registration cache for SSIS script task and data flow script componentREG DELETE HKLM\Software\Microsoft\VSTAHost\SSIS_ScriptTask /fREG DELETE HKLM\Software\Microsoft\VSTAHost\SSIS_ScriptComponent /f@rem delete the cached files from the HDDrd /s /q "%AppData%\Microsoft\VSTA"rd /s /q "%AppData%\Microsoft\VSTAHost\SSIS_ScriptTask"rd /s /q "%AppData%\Microsoft\VSTAHost\SSIS_ScriptComponent"rd /s /q "%USERPROFILE%\Local Settings\Application Data\VSTA"rd /s /q "%USERPROFILE%\Local Settings\Application Data\VSTAHost\SSIS_ScriptTask"rd /s /q "%USERPROFILE%\Local Settings\Application Data\VSTAHost\SSIS_ScriptComponent"@rem re-generate the VSTA files for SSIS script task and component"%ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe" /hostid SSIS_ScriptTask /setup"%ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe" /hostid SSIS_ScriptComponent /setup@rem end batch fileHope it helps, This posting is provided "AS IS" with no warranties, and confers no rights

I had this problem with SQL 2008 and Windows XP. I followed Silviu's steps and resolved my issue instantly, no reboot required. Make sure to create the batch file as recommended and be patient and wait for it to close (may take a while for vsta to complete).

Thanks so much, Silviu. I had the same problem mentioned above and your fix worked like a champ!

I tried your recommended batch file, but now I get the following error when I click on the "Edit Script" button: Cannot find one or more components. Please reinstall the application. Cannot show VS 2008 Tools for Applications editor.The VSTA designer failed to load: "System.Runtime.InteropServices.COMException... Error HRESULT E_FAIL has been returned from a call to a COM component. at VSTADTEProvider.Interop.VSTADTEProviderClass.GetDTE... at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()" (Microsoft.SqlServer.VSTAScriptingLib) Where can I find the "setup" file/folder?

Thanks for those instructions, Silviu. I modified them a bit and got the problem solved. - I had to replace %ProgramFiles% with the C:\ProgramFiles (x86) path. - The "delete the cached files from the HDD" couldn't find those folders either, so I manually deleted them from here:C:\Documents and Settings\<my username>\Application Data\Microsoft\VSTAHost- Under the "delete the VSTA registration cache for SSIS script task and data flow script component" , those paths were invalid so I manually deleted registry folders in:HKLM\SOFTWARE\Wow6432Node\Microsoft\VSTAHostThe differences may be due to me running Win Server 2003 x64.CalgaryCoder

I've tried all the suggestions in this thread and still I cannot get the "Edit Script" button in the Script Task control to work within a SSIS project within VS2008. What's strange is when I take the script given above and run it, most of the stuff is not found to remove or delete. Anyone actually know the cause and sure fire solution to this?

I have this prob as well. Has everyone affected had multiple versions of SSIS and/or VS?

I fixed it by going to Control Panel/Add Remove Programs and removing Microsoft Visual Studio Tools for Applications 2.0. Then reinstalled by getting the SDK from Summit Software here http://www.summsoft.com/VSTAInfReq.aspx Then did a .NET Framework 3.5 SP1 Repair with the installation from here http://www.microsoft.com/downloads/details.aspx?familyid=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=en Unfortunately I did not test before doing the .NET Framework 3.5 SP1 Repair, so I can't say for sure whether or not that was absolutely necessary, I'm just elated to have my Script Editor back! Sean

It works for me!!! Thank you SilviuJAC

That worked for me. With gratitude for your help, JS

Finally, after two days of shenanigans after installing SS 2008 R2, this script saved my bacon! Thanks, Silviu!Data Architect and Database Consultant Medford, Oregon

TITLE: Microsoft Visual Studio ------------------------------ Cannot show Visual Studio 2008 Tools for Applications editor. ------------------------------ ADDITIONAL INFORMATION: Specified cast is not valid. (EnvDTE) ------------------------------ BUTTONS: OK ------------------------------ I get the above error when trying to open an SSIS package script task script editor. The package had been working just fine, but now I am getting this error, and the script is running but it's not actually doing anything. I am not sure what "(under WoW32 on 64 bit platforms)" means, can you elaborate on that a bit. This is Visual Studio 2008 running on windows server 2008 (non R2) with service pack 2 on a 64 bit machine.

I found out what was causing this. We have an add-in called SQL Prompt 5 that we use in SSMS 2008 R2. When disabled in Visual Studio 9 > Tools > Add-in Manager this error went away.

It works for me!!! Thank you Silviu