Unable to create or open SSIS projects or maintenance plans in SQL Server 2012


April 25, 2013

Introduction

Off late I am not sure why I am Unable to create or open SSIS projects or maintenance plans in SQL Server 2012. This article explains how to troubleshoot this issue.

You may end up receiving the below mentioned error message when you create a SQL Server Integration Services 2012 project (SSIS 2012), or when you open an existing SSIS Project in SQL Server Data Tools (SSDT).

TITLE: Microsoft Visual Studio
------------------------------
The type initializer for 'Microsoft.DataTransformationServices.Design.SharedIcons' threw an exception.
------------------------------
ADDITIONAL INFORMATION:
Value of 'null' is not valid for 'stream'. (System.Drawing)

You may also end up receiving the below mentioned error message “When you create a maintenance plan, or when you edit an existing maintenance plan in Microsoft SQL Server Management Studio (SSMS).

TITLE: Microsoft SQL Server Management Studio
------------------------------
Provide value on 'System.Windows.Markup.StaticExtension' threw an exception. (PresentationFramework)
------------------------------
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
The type initializer for 'Microsoft.SqlServer.Graph.Extended.HighContrastSupport' threw an exception. 
(Microsoft.SqlServer.IntegrationServices.Graph)


It seen that one ends up getting the above mentioned errors if they have installed Cumulative Update 3 for SQL Server 2012 Service Pack 1. Read SQL Server 2012 Build List article to get the complete list of SQL Server 2012 Cumulative Updates, Hot fix and Service Pack information. A must have for an SQL Server Database Administrator.

How to Fix Unable to create or open SSIS projects or maintenance plans in SQL Server 2012 Issue

Microsoft has released a hot fix to resolve these issues. You need to download and install the hot fix from the following Knowledge Base Article.

Share this Article


Geeks who read this article also read…



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."