VS2012 Ultimate SSIS Start Up Error

If you are using Visual Studio 2012 (VS2012) for Business Intelligence solutions and have SQL Server 2012 SP1 installed, you may be running into a VS2012 Start Up issue. This happened to me this morning when trying to open a non BI solution in VS2012.

It came up with “Microsoft Visual Studio 2012 has stopped working” error message as shown below. I also tried running devenv /safemode as well, but this does not help.

VS2012 Crashed At StartUp

Essentially, the main issue was related to:

System.TypeLoadException: Could not load type ‘Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils

This issue happened on on my machine with SQL Server 2012 SP1 with KB2793634 (v11.0.3128) installed.

After tweeting it online, Jeff Rush (@JeffRush) mentioned a link that suggests SQL Server 2012 SP1 CU4 may need to be applied. Applying SQL Server 2012 SP1 CU4 (and also restarted my machine) didn’t seem to do the trick.  I did some more research and eventually found out that the problem was only solved in SQL Server 2012 SP1 CU5.

Applying the patch (part of hotfix included in SQL Server 2012 SP1 CU 5), 465914_intl_x64_zip.exe has solved the issue. After the patch, my SQL Server 2012 version is 11.0.3373.

Massive thanks to Jeff Rush for giving me a guidance that the issue was probably fixable with a hotfix for SSIS – not sure why I did not think of that. (That’s why Twitter and #SQLFamily rocks!)

Further Reading

Fix: The type initializer for ‘Microsoft.DataTransformationServices.Project.SharedIcons’ threw an exception. (Microsoft Visual Studio 2012) by Roel van Lisdonk

System.TypeLoadException: Could not load type ‘Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils’ on SQL Server Forums

Cumulative Update package 5 for SQL Server 2012 SP1 on Microsoft Support

 

 

5 comments on “VS2012 Ultimate SSIS Start Up Error
  1. I started getting this same error and searched literally EVERYWHERE for a solution!!! Uninstalled and reinstalled VS…reinstalled SQL Server, sacrificed a goat…everything!!!

    THANK YOU!!! You’re my new heroine!!

  2. Hi MsSQLGirl..

    .. any suggestions when ‘SQL Server 2012 SP1 CU5’ dosn’t do the job?

    Still got an error:
    The type initializer for ‘Microsoft.DataTransformationServices.Project.SharedIcons’ threw an exception.

    /MOE

    • Hi MOE,

      I’m not sure why that is. Can you confirm that the patch has been installed successfully? You can check by running the following command on the server:
      SELECT @@VERSION

      Hope this helps. If you find a solution to this already, please feel free to share it here.

      Thank you,
      Julie

  3. Hi Julie,

    The patch was installed successfully and everything, but nothing changed.

    The computer I’m using to develop had only a SQLEXPRESS installed – after I upgraded to an Enterprise Edition it worked again.

    Br,
    MOE

Comments are closed.