I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design 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 a Script Task or a Script Component, I click on the Design 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
|||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 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.
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
No comments:
Post a Comment