SSIS 2012 Script Task Exception : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

11 בנובמבר 2012

Problem : A 64Bit Development Machine ( Win 7 x64 , because of installed SharePoint 2010 ) with Visual Studio running / debugging an SSIS 2012 Project which contains a “Script Task” that tries to retrieve data from an Excel 2010 file While debugging the script , there is an exception The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Solution : They say a picture is a thousand words In words...
תגובה אחת

Visual Studio 2010 / SSIS 2012 [ Sql Server 2012 ] Toolbox ( “I can’t see my SSIS 2012 toolbox in VS 2010” )

8 בנובמבר 2012

For some reason , you can’t develop SSIS 2012 Packages on Visual Studio 2012 , the Business Intelligence Projects of the Sql Server 2012 resides on Visual Studio 2010On the other hand I have problem updating SqlServer 2012 Stored Procedures on the Visual Studio 2010 … but that’s another story Problem :I can’t see my SSIS 2012 toolbox in Visual Studio 2010 lets’ show it visually – there is no SSIS toolbox , all you see is “GENERAL”Solution :Usually when the Visual Studio Toolbox doesn’t appear correctly .. I go out and do the following : Open a...