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

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


4
0
Sign in
to vote
ID 367845 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 9/15/2008 1:22:28 PM
Access Restriction Public

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)
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