Adlai Maschiachhttp://blogs.microsoft.co.il/adlaim
" You have to show in order to be seen "Fri, 27 Dec 2013 03:48:06 +0000he-ILhourly1https://wordpress.org/?v=5.0.2SSIS 2012 Script Task Exception : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machinehttp://blogs.microsoft.co.il/adlaim/2012/11/11/ssis-2012-script-task-exception-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine/
http://blogs.microsoft.co.il/adlaim/2012/11/11/ssis-2012-script-task-exception-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine/#commentsSun, 11 Nov 2012 15:05:30 +0000http://blogs.microsoft.co.il/?p=1432605Problem :

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 :

Go to the property of the project >> debugging >> Set Run64BitRunTime to False

Why ?

In my case this is due to the fact that the installed version of Office 2010 is an 32 bit version, so the corresponding driver is an 32 bit one ( I have tried to install the 64bit driver , it doesn’t allow it self to be installed because of the version of the office is an 32Bit one )

Notice :

when running the package outside of the development environment on x64 computers, make sure to use the 32Bit versions of DTExec.exe and DTExecUI.exe utilities (one way to establish whether this is the case involves verifying that they are located within the Program Files (x86)\Microsoft SQL Server folder structure). In addition, when scheduling to run such packages as SQL Server Agent jobs, enable Use 32 bit runtime checkbox on the Execution options tab of the New Job Step dialog box (in the job's Properties dialog box of the SQL Server Management Studio interface).

For Visual Studio 2010 delete certain files that serve the same purpose

del "%LocalAppData%\Microsoft\VisualStudio\10.0\*.tbd"

… ok , after this didn’t work , finally found it !

( in this part , a picture is the best solution for “what & where” )

it seems that two buttons were added for this , just click each one of them !

]]>http://blogs.microsoft.co.il/adlaim/2012/11/08/visual-studio-2010-ssis-2012-sql-server-2012-toolbox-i-cant-see-my-ssis-2012-toolbox-in-vs-2010/feed/2TSQL: Concatenate Column from Multiple Rows into Stringhttp://blogs.microsoft.co.il/adlaim/2012/01/24/tsql-concatenate-column-from-multiple-rows-into-string/
http://blogs.microsoft.co.il/adlaim/2012/01/24/tsql-concatenate-column-from-multiple-rows-into-string/#commentsTue, 24 Jan 2012 10:48:58 +0000http://blogs.microsoft.co.il/?p=996185Ok , 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 )

The manipulation was that the of the “GROUP BY” was sent to the UDF to use in it’s select “where” , so it could return the filtered row concatenated. And that UDF was called as part of the grand SELECT.

NOTE: this is a developer solution , a DBA might have a better solution

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 needed for my SharePoint Content

BTW , there might be a better way to code this , but i’m no T-SQL expert

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 for you to easily build and manage composite applications, including:

Enhanced design and development tools in Visual Studio to build rich composite applications

Management and monitoring of services and workflows via integration with IIS Manager and Windows PowerShell

If we’ll go to the Download of the Windows Server AppFabric RC , we’ll see that the file is 41.4 MB ( for each CPU version ) , which only makes you wonder if by SP2 of SharePoint 2010 , we won’t expect to have an integration between the both ( SPS2010 & AppFabric ) !

I know that the SPTeam said that they don’t expect that the SPS2010 will have support to WF 4 , but that doesn't mean it won’t integrate with something that does OR have a change of heart and add it like WCF & WF was supported in BT2006R2 ( as an AddOn )

Ohh ,yeh , one more thing , it would have integration with the new Visual Studio 2010 [ Like dahh ]

]]>http://blogs.microsoft.co.il/adlaim/2010/05/23/biztalk-2010-beta-1-amp-appfabric-rc/feed/1Visual Studio 2010 – The type or namespace name 'MyClassLibrary' could not be foundhttp://blogs.microsoft.co.il/adlaim/2010/05/03/visual-studio-2010-the-type-or-namespace-name-myclasslibrary-could-not-be-found/
http://blogs.microsoft.co.il/adlaim/2010/05/03/visual-studio-2010-the-type-or-namespace-name-myclasslibrary-could-not-be-found/#commentsMon, 03 May 2010 08:52:22 +0000http://blogs.microsoft.co.il/?p=608886Visual 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.

The .NET Framework 4 Client Profile is a subset of the .NET Framework 4 that is optimized for client applications. It provides functionality for most client applications, including Windows Presentation Foundation (WPF), Windows Forms, Windows Communication Foundation (WCF), and ClickOnce features. This enables faster deployment and a smaller install package for applications that target the .NET Framework 4 Client Profile.

If you are targeting the .NET Framework 4 Client Profile, you cannot reference an assembly that is not in the .NET Framework 4 Client Profile. Instead you must target the .NET Framework 4. For more information, see Troubleshooting .NET Framework Targeting Errors.

What about CPU and memory limits? Are any other limits changed in SQL Server 2008 R2 Express? No, the database size limit is the only limit we updated in SQL Server 2008 R2 Express. SQL Server 2008 R2 Express is still limited to 1 CPU and 1 MB or RAM.