I cannot see the code associated with script component, what could be going on here?
Thanks
Technology Tips and News
I cannot see the code associated with script component, what could be going on here?
Thanks
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
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
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
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 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 :-(
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
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.11610I 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?