Script Component -

Script Component -

• iacido

  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.

  
  

• hhampa

  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
  
  

• Neil McLaughlin

  (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.

  
  
  

• Kui

  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

  
  

• iamhtran

  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

  
  

• jvervoorn

  I've just had the same problem.
  Has this been registered as a bug
  
  -Jamie
  
  
  

• Clifflane

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

• Ritesh Mehta

  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.

  
  
  

• Johan JvR

  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
  

• Zartaj

  That's right, I had C# projects.  After removing those from the solution, it works!
  Thanks,
  Harini
  

• karimkb

  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)

  
  

• andrewbelcher

  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.
  
  
  

• Johan Hertz

  Excellent. Thanks Michael.
  
  

• fumble

  Yes, it will be fixed for SP1.
  
  
• Script Component -