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