Home Dashboard Directory Help
Search

The system cannot find the file specified. (Exception from HRESULT: 0x80070002) (EnvDTE80) by Rokky


Status: 

Closed
 as By Design Help for as By Design


4
0
Sign in
to vote
Type: Bug
ID: 367845
Opened: 9/15/2008 1:22:28 PM
Access Restriction: Public
2
Workaround(s)
view
3
User(s) can reproduce this bug

Description

(Operating System is XP Professional SP3) In SSIS 2008, when attempting to edit a script, for tutorial 5, I receive the error "The system cannot find the file specified. (Exception from HRESULT: 0x80070002) (EnvDTE80)". Additional messages below...

===================================

Cannot show Visual Studio Tools for Applications editor. (Microsoft Visual Studio)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2008&ProdVer=9.0.30729.1&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVSTAIDE&LinkId=20476

===================================

The system cannot find the file specified. (Exception from HRESULT: 0x80070002) (EnvDTE80)

------------------------------
Program Location:

at EnvDTE80.Solution2.GetProjectTemplate(String TemplateName, String Language)
at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String languageID, String projectname, String projectext, Boolean bCleanupOnClose)
at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String languageID, String projectname, String projectext)
at Microsoft.SqlServer.Dts.Pipeline.VSTAComponentScriptingEngine.CreateDesignTimeEngine(String projectName, Boolean loadSource, IVSTACodeGenerator codeGenerator)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ShowIDE()
at Microsoft.DataTransformationServices.DataFlowUI.ScriptUI.propPage_DesignScript(Object sender, EventArgs args)
Details
Sign in to post a comment.
Posted by MS World Fan on 8/27/2009 at 6:46 AM
I've the same problem,

I reinstalled sql server 2008 and even installed visual studio tools for applications.... but still the problem persists.

can anybody provide the solution???

Thanks

Posted by Microsoft on 6/29/2009 at 5:06 PM
I am unable to reproduce this issue. You're best bet is to reinstall SSIS on a clean machine if the workaround mentioned here did not work.
Posted by ahboy on 6/8/2009 at 1:34 AM
Hi Silviu,

I encounter the exact same problem described in this post. I followed your workaround but the problem still persist. Do you have any other workaround worthwhile?
Posted by Silviu Guea - MSFT on 10/13/2008 at 1:21 PM
Hi again,

To add to my previous post, it looks like the installation you have is corrupted. You can try to repair it by doing the following:
a) running repair on the SQL install or reinstall SQL Server Integration Services to make sure everything is repaired.
b) to try and fix an eventual localized installation issue related to scripting in SQL Server Integration Services you can try running the following commands from Start->Run command prompt:
vsta /hostid SSIS_ScriptTask /setup
vsta /hostid SSIS_ScriptComponent /setup

Let me know if this worked for you.

Silviu Guea [MSFT],
SQL Server Integration Services
Posted by Silviu Guea - MSFT on 9/24/2008 at 3:54 PM
Hi ROKKY,

Looks like the installation you have is corrupted. You can try to repair it by doing the following:
a) to try and fix an eventual localized installation issue related to scripting in SQL Server Integration Services you can try running the following command from Start->Run command prompt: vsta /hostid SSIS_ScriptTask /setup
b) running repair on the SQL install or reinstall SQL Server Integration Services to make sure everything is repaired.

Let me know if this worked for you.

Silviu Guea [MSFT],
SQL Server Integration Services
Sign in to post a workaround.
Posted by Silviu Guea - MSFT on 10/13/2008 at 1:19 PM
Also run
run the following command from Start->Run command prompt: vsta /hostid SSIS_ScriptComponent /setup
Posted by Silviu Guea - MSFT on 9/24/2008 at 3:55 PM
run the following command from Start->Run command prompt: vsta /hostid SSIS_ScriptTask /setup