Cannot edit code or see code in SQL 2012 Denali SSIS script task
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
March 9th, 2012 4:20pm

Remove all third-party addonsArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 4:27pm

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
March 9th, 2012 4:31pm

did not help Gokhan Varol
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 4:32pm

Try renaming the script.Arthur My Blog
March 9th, 2012 4:33pm

I am trying a brand new package now it's not working in this server, on another server the same thing is fineGokhan Varol
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 4:33pm

I renamed the script, no good :-( Gokhan Varol
March 9th, 2012 4:34pm

Did you check for any pending updates, SPs?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 4:38pm

meaning windows updates?Gokhan Varol
March 9th, 2012 4:38pm

yes, correctArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 4:39pm

I suggest since the RTM is available on MSDN you better get that one instead of using the "Denali".Arthur My Blog
March 9th, 2012 4:41pm

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 whileGokhan Varol
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 4:42pm

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
March 9th, 2012 4:43pm

I cannot see the code associated with script component, what could be going on here? Thanks Gokhan Varol
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 8:04pm

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 itGokhan Varol
March 9th, 2012 8:09pm

Was it an AcriveX script in the original package? This could be the reasonArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 9:31pm

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 issueGokhan Varol
March 9th, 2012 9:49pm

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 StudioArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 10:00pm

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
March 9th, 2012 10:04pm

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
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2012 11:56pm

Uninstall now any 3-rd party tools.Arthur My Blog
March 10th, 2012 12:09am

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 ThanksGokhan Varol
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2012 12:19am

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
March 30th, 2012 12:15pm

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
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2012 12:44pm

So the remedy was in rebuilding the machine, right?Arthur My Blog
March 30th, 2012 2:09pm

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
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2012 3:28pm

Thank you for sharing and good luck with the MCM exam!Arthur My Blog
March 30th, 2012 3:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics