Script Component -

Hi,
In our office recently installed VS .net 2005 RC and Yukon Sep. CTP.

The problem is, create a dtsx package. Drag and drop a script component in dataflow after a OLEDB source. Let the script component be transformation type.
Edit it, click on scripts in the left hand side tree, double-click on the button 'design script' (right bottom corner). I get an error:

TITLE: Microsoft Visual Studio
------------------------------

Cannot show Visual Studio for Applications editor.

For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.26&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The method or operation is not implemented. (Microsoft.DataWarehouse.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

If anybody has solution for it, pls let me know.
Thanks
Harini

Answer this question

Script Component -

LGS
That's right, I had C# projects. After removing those from the solution, it works!
Thanks,
Harini
wagnerjp
I've just had the same problem.
Has this been registered as a bug

-Jamie
kiranla
Yes, it will be fixed for SP1.
Gilles Noël

Andrew, the order of installation doesn't matter. The fact that there is a C# project in the same solution (as the IS project) is what's causing trouble. Removing the C# project will do the trick.
DonD
Got similar problem:

The solution only had one IS project.

Error detail:

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

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

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

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa.DT)

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

at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.ShowIDE(Boolean showOrHide)
at Microsoft.SqlServer.VSAHosting.DesignTime.ShowIDE(Boolean showOrHide)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ShowIDE()
at Microsoft.DataTransformationServices.DataFlowUI.ScriptUI.propPage_DesignScript(Object sender, EventArgs args)

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

Interface not registered (Exception from HRESULT: 0x80040155) (Microsoft.Vsa)

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

at Microsoft.Vsa.IVsaIDE.ShowIDE(Boolean showOrHide)
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.ShowIDE(Boolean showOrHide)
Rainer Queck
I got my machine imaged by IS team. I don't know the order of installation.
But I can tell you what I did.
There were 2 projects in my solution where I got the error. One is the SSIS and another one is C# project. After removing the C# project from the solution, I dont get error.
Note that executing .exe (C#) through execute process task is not causing any problem.
Let me know if you need more info.
Thanks,
Harini

yoni sher

Hi,

I have just tried this in a simple package in a SQL Server only install and 
in a SQL Server plus Visual Studio install. Both work correctly.

What order did you install Visual Studio and SQL Server 

Andrew Watt
MVP - InfoPath

 wrote in message 
news:2443da4e-d234-4d6a-a8c0-373c8fd1655c@discussions.microsoft.com...
> Hi,
> In our office recently installed VS .net 2005 RC and Yukon Sep. CTP.
>
> The problem is, create a dtsx package. Drag and drop a script component
> in dataflow after a OLEDB source. Let the script component be
> transformation type.
> Edit it, click on scripts in the left hand side tree, double-click on
> the button 'design script' (right bottom corner). I get an error:
>
> TITLE: Microsoft Visual Studio
> ------------------------------
>
> Cannot show Visual Studio for Applications editor.
>
> For help, click:
> http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u0
> 0ae+2005&ProdVer=8.0.50727.26&EvtSrc=Microsoft.DataTransformationService
> s.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> The method or operation is not implemented.
> (Microsoft.DataWarehouse.VsIntegration)
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
> If anybody has solution for it, pls let me know.
> Thanks
> Harini
>
>

Charles Wildner
Hi,

I am using Microsoft Accounting Expresss 2007 and I cannot use the Word templates that came with the program; when I try to, I get this message:
```
The following Word error occured: Interface not registered (Exception from HRESULT: 0x80040155)
```
I have this same program downloaded on my work computer and it works just fine; I cannot think what the problem may be and I am not a 'techie' person. Can anyone help me I posted my query on Microsoft's Small Business Accounting Discussion Group and no one has helped so far.

Thanks in advance.

Yasmin
gagan

(I think the underlying cause is something to do with .Net 3.0 install, Maybe the installation of SQL2005 SP2, or maybe the order of install between VS2005 and SSIS, but whatever the reason, there is a registry issue.

First, do make sure your SSIS service has appropriate login rights.

Also, navigate to the following folders:

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\common\

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\vsa

In each of those folders run this command to re-register everything in there.:

for %i in (*.dll) do RegSvr32 -s %i

You will be very pleased with the results I think. May be a little blunt, but it worked for me.

I had determined this was the issue from the detailed error message provided in the dialog, where it indicated the problem was the program Microsoft.VisualBasic.Vsa.Dt.get_extensibility.... blah blah, and another message saying "interface not registered". Putting 2 and 2 together, I did a search for that dll, and registered everything in that folder and the other one. I recognize a COM error when I see one :).

There are a few people on forums starting to post this issue, and there don't seem to be any responses, so tell everyone you know, because I'm sure it will be a common problem among SSIS developers who use scripting.
Stephen Castle
Excellent. Thanks Michael.
johnnygoodface
There is a bug that can cause this error when you have a non-Integration Services project (such as a C# application) in the same Visual Studio solution as your package.

I got this same error message the other day, but after I closed VS and rebooted, it didn't come back.

Hope this helps,

-Doug

Dnm77

GJGrosso wrote:

Harini: Did you ever get a fix for this If so please forward it to me. I have spent two days on this. I am about ready to give up and just write a c# component instead of using SSIS. Thanks.

Did you see the post marked as the answer Right below that Harini states that was the problem and is now fixed.

Dennis Miller
Harini: Did you ever get a fix for this If so please forward it to me. I have spent two days on this. I am about ready to give up and just write a c# component instead of using SSIS. Thanks.
Bridgepark
For me, the error came out on the File Watcher Task (http://www.sqlis.com/23.aspx) and stated that it was unable to load Microsoft.ExceptionMessageBox assembly. I downloaded and installed Microsoft EMB* and it worked!

*Link: http://www.microsoft.com/downloads/details.aspx familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Hope this saves a few minutes of another frustrated developer.

Narayan
Script Component -

Answer this question