Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Solution to VSTA editor error in SSIS 2012

The script task in SSIS 2012 is a great tool when you need to use C# or VB code to perform a function that is not possible with the other SSIS built-in tasks.  It uses Visual Studio Tools for Applications (VSTA).  One of the limitations when using the script task is if there is a problem with the code, when you try to execute the task you get a generic error message:

So you must set a breakpoint in the script task so you can debug it and get a more descriptive error message.  However, I got an error when trying to open the script task editor.  It said “Cannot show Visual Studio 2010 Tools for Applications editor.  Could not load file or assembly ‘Microsoft.VisualStudio.Tools.Applications.Core’…The System cannot find the file specified.”:

I never had this problem before when using servers that solely had SQL Server 2012 installed, but in this case this server had both SQL Server 2008 and SQL Server 2012 installed.  That combination seemed to be the cause, and after much trial and error I performed the following steps to clear up the problem:

  • Uninstall SSIS 2008
  • Uninstall SSIS 2012
  • Uninstall VSTA (3 versions).  You should see the three versions to uninstall when viewing the list in control panel (the bottom three below):
  • Install SSIS 2012 and SSDT (which automatically installs VSTA).  Note the prerequisite box mentions it will install VSTA:

I tried skipping the steps that uninstall SSIS 2008 and SSIS 2012, and was able to get the editor working, but when I tried to execute the script task I got the same error:  ”Cannot show Visual Studio 2010 Tools for Applications editor.  Could not load file or assembly ‘Microsoft.VisualStudio.Tools.Applications.Core’…The System cannot find the file specified.”:

Comments

Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...