I cannot see the code associated with script component, what could be going on here?

Thanks

FYI: When I open the package in a text editor I can see the code inside the package file. Somehow the designer is not showing it

Was it an AcriveX script in the original package? This could be the reason

nope plain c# code, but I guess my installation is corrupt, on another installation this was not an issue. I am currently uninstalling vs2010, and then sql server shared features and then reinstall them back hoping that will resolve the issue

Before un-installing you could do a couple of things. I can see you have too many third-party tools installed, I guess they have cause this.

I typically do

Devenv /ResetSettings

Then un-install 3-d party components.

And only then the Visual Studio

Thank you for the tip, I am saving this aside for the next time I run into a similar problem, I am currently in the middle of the uninstall, already hit the red button and launched the nuclear bomb and praying on the right on 4 different religion :-).

I uninstalled visual studio 2010, I uninstalled sql server shared features, reinstalled visual studio 2010, reapplied visual studio service pack 1, reinstalled sql server 2012 shared features. I did "Devenv /ResetSettings" and I am back where I started, the script component shows blank, no files nothing but package xml has the code.

Any ideas ?

Thank you

Cannot edit code or see code in SQL 2012 Denali SSIS script task. I literally totally reinstalled visual studio 2010 and sql server 2012 but this issue did not go away. Please advise

Thank you

Uninstall now any 3-rd party tools.

Remove all third-party addons

You know, I now think there could be a problem with the name of the script. What is it? Try renaming it and then opening it up.

did not help

Try renaming the script.

I am trying a brand new package now it's not working in this server, on another server the same thing is fine

I renamed the script, no good :-(

I want to continue on the other thread, I though the issue was upgraded packages , but the issue is something with the installation itself, even on a new package I get the same problem

Cannot edit code or see code in SQL 2012 Denali SSIS script task

Thanks

Did you check for any pending updates, SPs?

meaning windows updates?

yes, correct

I suggest since the RTM is available on MSDN you better get that one instead of using the "Denali".

there is some updates coming but I am in the conferenceroom listening to Jonathan Kehayias from SQLSkills and we have a bad internet connection, the updates gonna take a while

yes  I downloaded the RTM yesterday and installed that on 4 of our servers, 2 server is fine, my notebook is where I am sending screenshots no good and another server is no good, we do not have any pre release versions at all.

Hi Gokhan,

Do you see the following listed as installed Programs on your system:

Microsoft Visual Studio Tools for Applications Design-Time 3.0
Microsoft Visual Studio Tools for Application x64 Runtime 3.0
Microsoft Visual Studio Tools for Application x86 Runtime 3.0

Thanks,

Cathy Miller

I had to rebuild my server from scratch and have a fresh install now. I do not have access to the failed machine anymore.

So the remedy was in rebuilding the machine, right?

I end up replacing windows 7 with windows 2008 R2 hyper v and installed couple more windows 2008 R2's on it to test sql 2021 clustering and always on and stuff , it was worth it. I had to get prepared for MCM exam anyway it worked out. 

But it did certainly not make me gain confidence on sql 2012 upgrade :-(

Thank you for sharing and good luck with the MCM exam!

This resolved the issue for me.

My problem was that I had Source Control enabled. As soon as I disabled it everything worked.

You can disable it by clicking Tools --> Options --> Source Control --> Plug-in Selection and then selecting "None" in the Current Source Control Plug-in dropdown.

Hope this helps

So, I've just installed SQL 2012 RTM on a fresh install of Windows 7 and I get this exact behaviour on SSIS script tasks too - completely blank even on newly created projects.

In response to the existing comments:
There are no third party add-ins
The relevant VSTA items are listed in add/remove programs
I've turned off source control

The script tasks do have some code in - in fact my test package runs fine. I just can't see/edit any source.

Actually - I only turned off source control in VSTA... When I turned it off in the main Visual Studio everything worked.

It still works now I've re-enabled source control.

There seems to be a conflict with Windows Folder Redirection - every time I log off one computer (with SQL 2012 installed) login to another (without it installed) and back to the original computer my settings are screwed and I have to disable/reenable the source control provider.

I was able to resolve this by setting the Tools | Options | Source Control Plugin to "None" from AnkhSVN. However, setting it back to Ankh reintroduces the symptom, but at least I can debug my Script Component. 

Thanks for the suggestion.

* Ultimately resolved the issue by upgrading AnkhSVN to version 2.4.11610

• Edited by DrDvorak Thursday, June 06, 2013 1:57 PM Update

I began this thread feeling confident that my answer is here.  I have done everything listed and Nothing has worked.  No add-ons, reinstalls, all 3 parts of VSTA are here, source control off, in both VSTA and Visual Studio.  I'm running VS2013 and SSDT for Visual Studio 2013, Sql Server 2014 Developer.  What should I try next? 

I am having same problem in VS 2012. Rebuild, reboot sometimes works. Delete entry point 'Main', Build, add entry point 'Main' rebuild: sometimes works. My Productivity is down significantly. Surprised MS has no answer for such a crippling bug.