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

TSQL: Concatenate Column from Multiple Rows into String

24 בינואר 2012

Ok , So I had a problem related to concatenation of a single Column into one ( same ) column when using GROUP BY . The Problem came from a Reporting Services perspective and there might be other solutions ( like coding in VB.NET in the report ) I have found a very nice samples : Option 1: use Northwind declare @CategoryList varchar(1000) set @CategoryList ='' select @CategoryList = @CategoryList + ' , ' +...

SharePoint 2010 : The following computer running SharePoint does not contain the required Infopath form template

23 בינואר 2012

What can I say … except "elementary my dear Watson" ;) Ok , the problem is that you didn’t activate a feature in the site you’re working with :P go to : Site Actions > Site Settings > Manage Site Features > Team Collaboration Lists. The problem : The solution: ( Personal Note: I know it has been a while , but once in a while doesn’t hurt ;)  )

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 תגובות

BizTalk 2010 Beta 1 & AppFabric RC

23 במאי 2010

BizTalk 2010 Beta 1 & AppFabric RC On the 20th , BizTalk 2010 Beta 1 was released ,  a day after the AppFabric RC. We all know ( at least a bit ) about BizTalk , but regardless we shouldn’t disregard the Windows Server AppFabric which is a set of integrated technologies that make it easier to build, scale and manage Web and composite applications that run on IIS. Windows Server AppFabric targets applications built using ASP.NET, Windows Communication Foundation (WCF), and Windows Workflow Foundation (WF). It provides out-of-the-box capabilities...

Visual Studio 2010 – The type or namespace name 'MyClassLibrary' could not be found

3 במאי 2010

Visual Studio 2010 - The type or namespace name 'MyClassLibrary' could not be found I have run across this message in the Beta Edition of Visual Studio 2010 , and I dismissed it as a Beta feature . But now with the release version , for me , that message was a bit out of place . It seems that the solution , as far as I’m concern , is very simple , change the Target to “.NET Framework 4” and everything is going back to normal.   If you’ll look closely...
17 תגובות

Express 2010 RTM Download summary

29 באפריל 2010

Express 2010 RTM Download summary Any one who really knows me , knows that my 2nd passion is the Express toolset :) Now, that Visual Studio 2010 has RTM-ed a few days (weeks) a go I have decided to build a small collection of relevant URLs : from Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express ( Part of the WebPI Toolkit ) All - Offline Install ISO image file And the SqlServer Express 2008 R2 – with the new 10GB support :) Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services Microsoft SQL Server 2008 R2 RTM...

"How Do I" Videos SharePoint Development with Visual Studio 2010

"How Do I" Videos SharePoint Development with Visual Studio 2010 This reminds me of an old post I did .. Moss 2007 and Designer Webcast How-To is growing , and a few more like SharePoint Developer Training and Webcast Series: SharePoint for Developers and … but that’s ancient history ,and it’s Moss2007. Now, we start to talk about SharePoint 2010 ! So, here’s a small and growing list : #1 | How Do I: Create Visual Web Parts for SharePoint 2010 in Visual Studio 2010? #2 | How Do I:...

Office 2010 RTM !

18 באפריל 2010

Office 2010 RTM ! Long time waited Office 2010 has finally RTM-ed. I know that some of use played around with the Office 2010 on the developer's side .. and some of use on the user/client side . So this news is what most of us have been waiting for a long time :) For me , this news come from the Microsoft Office 2010 Engineering blog - Office 2010 Reaches RTM! Specification .. knowing you , I guess you know already – the main thing is that now it’s RTM , so more reliable...