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...
תגובה אחת

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

SharePoint 2010 is just around the corner

יום שני, פברואר 15, 2010

SharePoint 2010 training material released in January: 2010 Information Worker Demonstration Virtual Machine (Beta) – fully functional virtual machines to demo Office 2010 and SharePoint 2010. Free E-learning: What’s new in Microsoft SharePoint 2010 for Developers. Free E-learning: What’s new in Microsoft SharePoint 2010 for IT Pros Learning snack for developers – Developing solutions with SharePoint 2010 SharePoint 2010 Developer material on Channel 9 SharePoint 2010 – Getting started with development on SharePoint 2010 – HOL in C# and...