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

Question

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

---

Gokhan Varol

Answer 1

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

Thanks

---

Gokhan Varol

Answer 2

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

---

Gokhan Varol

Answer 3

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

---

Arthur My Blog

Answer 4

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

---

Gokhan Varol

Answer 5

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

---

Arthur My Blog

Answer 6

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 :-).

---

Gokhan Varol

Answer 7

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

---

Gokhan Varol

Answer 8

Uninstall now any 3-rd party tools.

---

Arthur My Blog

Answer 9

Remove all third-party addons

---

Arthur My Blog

Answer 10

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.

---

Arthur My Blog

Answer 11

did not help

---

Gokhan Varol

Answer 12

Try renaming the script.

---

Arthur My Blog

Answer 13

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

---

Gokhan Varol

Answer 14

I renamed the script, no good :-(

---

Gokhan Varol

Answer 15

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

---

Gokhan Varol

Answer 16

Did you check for any pending updates, SPs?

---

Arthur My Blog

Answer 17

meaning windows updates?

---

Gokhan Varol

Answer 18

yes, correct

---

Arthur My Blog

Answer 19

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

---

Arthur My Blog

Answer 20

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

---

Gokhan Varol

Answer 21

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.

---

Gokhan Varol

Answer 22

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

Answer 23

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

---

Gokhan Varol

Answer 24

So the remedy was in rebuilding the machine, right?

---

Arthur My Blog

Answer 25

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

---

Gokhan Varol

Answer 26

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

---

Arthur My Blog

Answer 27

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

---

SteveC

Answer 28

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.

---

James

Answer 29

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.

---

James

Answer 30

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.

---

James