Hello,

I don't know if i am in the right forum, if not, please advise which to use as I am rather new at posting.

I have Visual Studio Ultimate 2012 V 11.0.50727.1 RTMREL.  installed products include SQL Server Data Tools V 11.1.20627.00

this has been working reliably for some time - i create SSIS packages in Visual Studio.  The last time I touched one was about 1 month ago and it worked fine.  Today my boss wanted a change to one of the SSIS packages.  I started Visual Studio and it threw this exception in my variables window:

Exception details:
System.TypeInitializationException: The type initializer for 'Microsoft.DataTransformationServices.Design.SharedIcons' threw an exception. ---> System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils' from assembly 'Microsoft.SqlServer.Dts.Design, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.

Failing to understand what that meant, i tried to open an SSIS package and got the following error in output tab:

 The type initializer for 'Microsoft.DataTransformationServices.Project.SharedIcons' threw an exception.

attempting to figure that out (bing/google), i found :  http://www.roelvanlisdonk.nl/?p=3436

which lead me to : http://social.technet.microsoft.com/Forums/en-US/829e1fca-fbbf-43d8-bde5-202ad95e8643/the-type-initializer-for-microsoftdatatransformationservicesdesignsharedicons-threw-an

which told me to apply CU5.

so i followed hopefully the correct links and got a download file.   attempting to run it to apply CU5, it tells me the installed SQL Server product version is 11.0.2100.60 and the expected is 11.1.3000.0

Yet when i look at my installed program list, my SQL 2012 version is 11.1.3000.0 (Service Pack 1 for SQL Server 2012 (KB2674319) AND version 11.1.3128.0 (GDR 3128 for SQL Server 2012 (KB2793634)  so i don't know why CU5 thinks i am not on v 11.1.3000....

Please help... is my system as confused as I am?

What do i do now?

Thanks in advance for your help.

attempting repair on Visual Studio Ultimate 2012 via Control Panel -> Programs -> Programs and Features.

Hi NormaJean,

The product version 11.0.2100.60 represents SQL Server 2012 RTM(not SP1), you need to make sure that the SP1 installation for SQL Server 2012 is successful. Then you can update to cumulative update package 5 for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1. For more information about how to identify SQL Server version, see, http://sqlserverbuilds.blogspot.ca/.

Based on your description, you check the SQL Server version is 11.1.3000.0 in installed program list, it not means you install a complete package for SQL Server2012 Sp1 instance ,  I recommend you run this SQL query to display the actual SQL instance version via SQL Server Management Studio,

Select @@version

If you have SP1 installed, it should show "Microsoft SQL Server 2012 (SP1) - 11.0.3000.0..."

Regards,
Sofiya Li