I am having a problem in the Business Intelligence Development Studio. When I add and try to edit aScript Task or a Script Component, I click on theDesign Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

How odd! I havent' idea.. Maybe this is a stuff related with the own assembly? Look at c:\windows\assembly and make sure that exists Microsoft.Vsa.Hosting.Design Time assembly. I'm sorry

reedcbr wrote: I am having a problem in the Business Intelligence Development Studio. When I add and try to edit aScript Task or a Script Component, I click on theDesign Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help! does other control flow objects and data flow transformation experience the same

reedcbr wrote: I am having a problem in the Business Intelligence Development Studio. When I add and try to edit aScript Task or a Script Component, I click on theDesign Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help! does other control flow objects and data flow transformation experience the same

Those are the only two that I have noticed it in. Are there other objects that have Design Script buttons. If so, I will test them and reply with an answer.

Yes, the assembly is there. Its' version is 8.0.0.0 and its' public key token is b03f5f7f11d50a3a

Yes, the assembly is there. Its' version is 8.0.0.0 and its' public key token is b03f5f7f11d50a3a

I am wondering if anyone is monitoring this forum, I posted answers to the questions that I was asked and haven't received any more responses.

Well, perhaps a reinstall is in order... Nevermind... Just read the whole thread.

I was just wondering if this could be happening because this desktop is running Windows XP Media Edition?

Do you have Visual Studio installed? If yes, can you try and and run : Tools-> Macros-> Macros IDE... and see if that works? Thanks, Ovidiu

hi, Weird thing happen to SSIS when the integration service does not have sufficient right in the Box. check to see if the integrarion service has sufficient rights click start>run>type "service.msc" look for the integration service and supply it with a powerful account in your box perhaps an administrator account. regards, joey

hi, Weird thing happen to SSIS when the integration service does not have sufficient right in the Box. check to see if the integrarion service has sufficient rights click start>run>type "service.msc" look for the integration service and supply it with a powerful account in your box perhaps an administrator account. regards, joey

I'm having the same problem, except when I click the Design Script button nothing happens, I don't even get an error message. Has anyone been able to find the solution for this? Tom

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

Your idea is on the right path. My initial error pointed me to the DTS folder under C:\Program Files\Microsoft SQL Server\90\DTS\Binn. I registered what you did above, but it did not work. I decided, hey lets try the DTS\Binn folder. What do you know, I no longer get the error and can see all my work flow in SSIS. Thanks for the tip (it appears security does not have to be set to Local User, but rather a solid Admin account). Thanks, TR

I have the same problem ins VS 2005, after I install SQL Management Studio 2008.I clcik on design Script and the dialog box closes, nothign happends, no error in the events log.anyone found a solution?

Installing the "Microsoft SQL Server 2005 Service Pack 3 (KB955706)" update fixes this issue.

I can confirm the MS SQL 2005 SP3 fixes the issue at once.

This happened to me too. I'm pretty sure it has to do with the order things were put on the machine. I had one machine with VB6, VS.NET 2003, 2005 and 2008, and SQL 200, 2005 and 2008, .NET 3.5 and all the latest service packs thereof. No issues. Then I got a new machine which was given to me with VS and SQL 2005 only. I installed all the others, and the SPs. After I was done I had this issue. After pulling my hair out for a few hours, I found this thread. Installing Microsoft SQL Server 2005 Service Pack 3 fixed it immediately.On a side note, a previous post mentioned registering everything in:C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\vsaMy machine does not have this folder. Apparently on mine it is named:C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\VsaEnvThanks to everyone for helping me solve this!Eric

I have Visual Studio 2008 and Visual Studio 2005 installed in my machine. Also, I have SQL 2008 and SQL2005 (client tools only). No problem on VS 2008 but on VS 2005, I can't open the design script button on script transformation editor, Got a pop-up message: "Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)" Additional information: The method or operation is not implemented. I'm wondering maybe some files was overwritten when I installed VS2008? any thoughts?

Thanks ElangoChd. I was having same issue as Juan DK after installing everything in my new PC. installing "MS SQL Server 05 SP3" fixed the issue.

There is simple resolution to your problem. Open your packager.Right click->view code and check for the name of your Script task .Copy the code and paste in notepad . Now delete the task and create a new task and copy and paste the code :)

There is simple resolution to your problem. Open your packager.Right click->view code and check for the name of your Script task .Copy the code and paste in notepad . Now delete the task and create a new task and copy and paste the code :) No offense, but that is a terrible suggestion. Say you had a project with 75 script components that were broke. Copy/paste everything out and back in??? Go with the install SP3 for SQLServer 05 and it will clear everything up

I just installed SP4 (SQL Server) and issue got fixed.

I had the same problem. After removing SQL Server 2005, installing SQL Server 2008 then installing SQL Server 2005 BIDS, I could not edit an SSIS script task. I ran the install for Microsoft SQL Server 2005 Service Pack 3, and now i am able to edit the script task. Thank you!