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

  After some automatic Windows updates, I was unable to open my SSIS projects in Microsoft Visual Studio 2012. The following error was shown: The type initializer for ‘Microsoft.DataTransformationServices.Project.SharedIcons’ threw an exception.   After a google search, I found the following solution at: http://social.technet.microsoft.com/Forums/en-US/829e1fca-fbbf-43d8-bde5-202ad95e8643/the-type-initializer-for-microsoftdatatransformationservicesdesignsharedicons-threw-an   Solution Download and install http://support.microsoft.com/kb/2861107 …

SSIS 2012 not showing correct Available External Columns in Xml Source Task.

  The “ORDER” type in the following XML document will not be shown in the available external columns dialog in SSIS 2012. <?xml version=”1.0″ encoding=”utf-8″?><ORDER>  <ID>1</ID>  <ORDERLINE>    <ID>1</ID>      <PRODUCTNAME>Test1</PRODUCTNAME>  </ORDERLINE>  <ORDERLINE>    <ID>2</ID>      <PRODUCTNAME>Test2</PRODUCTNAME>  </ORDERLINE></ORDER>   Result   If you want the ORDER type to show up, add a root element …

Installing SSIS support in Microsoft Visual Studio 2012

As of 5-mrt-2013, Microsoft Visual Studio 2012 supports SSIS projects by installing Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012   You can download Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 at: http://www.microsoft.com/en-us/download/details.aspx?id=36843   On installation I got the following error: …

Soloving the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered" in Microsoft SQL Server 2008 R2

When you don’t have Microsoft Office 2007 installed on a machine running Microsoft SQL Server 2008 R2 Integration Services, you might get the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered"   Solution To fix this problem: Download and install the ACE provider from the following link, this …