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...

T-SQL Israeli CardID Checker / ת.ז. ישראלית

יום שלישי, אוגוסט 24, 2010

T-SQL Israeli CardID Checker / ת.ז. ישראלית Once in a while I come across code that I didn’t fins in the internet … mainly because it’s for local use ;) This is one of these times :) This code is the T-SQL version of the algorithm  that checks the given Israeli CardID , and adds a leading Zero , if need one ( like in my personal case ) , and calculates the “Check Number” ( SIFRAT BIKORET ) , if it’s missing. I needed this for an SSIS Package that loaded monthly information...
69 תגובות

SSIS on Excel 2007 Data Import & Moss2007 :"Excel Source Output" . The column status returned was: "Text was truncated or one or more characters had no match in the target code page."

יום חמישי, ינואר 8, 2009

SSIS on Excel 2007 Data Import & Moss2007 One of the crucial stages in moving managers from the “Simple all I want I get from Excel” to a more centralized platform like Sharepoint is moving their data ! Well lately not only have I been a : “HTML” “SharePoint Designer 2007” “Adobe Photoshop CS2” & “Paint.Net” Graphics “General Specific Site Collection Moss2007 Admin” “InfoPath 2007 Browser Compatible Developer” (including InfoPath C# Code) “General Web Service &...

SQL Server 2008 Server Service Configuration

יום שני, מרץ 3, 2008

SQL Server 2008 Server Service Configuration Due to the fact that the SQL Server 2008 February CTP Is Now Available is the closest thing that there is to the SQL 2008 RTM, counting the seconds. I have decided to install this CTP. But, each time I have installed I've chosen all  possible options which is the DatabaseEngine AND the AnalysisServices AND the ReportingServices ... and EACH TIME the DatabaseEngine and ReportingServices would fail or if i've didn't check the SSAS then it would work. In the end i've found the right combination - here it is So...
אין תגובות

SQL 2008 RTM, counting the seconds

יום רביעי, פברואר 27, 2008

SQL 2008 RTM, counting the seconds need I say more ? The picture says all - from here : https://www.microsoft.com/sqlserver/2008/en/us/default.aspx Download from here : https://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx
תגובה אחת