Issues with corrupt script tasks in SSDT

• Lord Slaagh

  SSCertifiable

  Points: 5724

  More actions

  December 26, 2014 at 11:56 am

  #299800

  Hello and happy holidays!

  I am dealing with an odd issue here. I am in the process of "side-by-side" upgrade of SQL 2005 - 2012. We have the standard 3 environments (DEV, QA, PROD).

  The upgrade was successful and now I need to get the SSIS packages running. I have 1 master package that points to a single config file. The issue that I am having is that I am not able to edit script tasks on my DEV box, but the QA box has not issues.

  Any help would be appreciated.

  Here are my error messages...

  Could not load file or assembly 'Microsoft.VisualStudio.Tools.Apllications.Core, Version=10.0.0.0, Culture=neutral, The system cannot find the file specified (mscorlib)

  I also found the following link that says I need to install these files, but I am not sure if this is correct or relevant to my issue.

  https://connect.microsoft.com/SQLServer/feedback/details/776248/could-not-load-file-or-assembly-microsoft-visualstudio-tools-applications-core

  Everyone has a plan until they get punched in the mouth. --Mike Tyson