May 2010 – Knowledgebase

Microsoft SQL Server 2008 R2 setup starts, when you build a Visual Studio 2010 setup project

26 May, 2010 Roel van Lisdonk 5 Comments 1 category

When you build a Microsoft Visual Studio 2010 setup project a Microsoft SQL Server 2008 R2 setup might start. To solve this problem on a x64 system: regsvr32.exe /u "C:\Program Files (x86)\Common Files\microsoft shared\MSI Tools\mergemod.dll"

Solving: Microsoft Office 2010 does not support upgrading from a prerelease version of Microsoft Office 2010

25 May, 2010 Roel van Lisdonk 10 Comments 1 category

After removing Microsoft Office 2010 beta 1 from my system I could install Microsoft Office 2010 RTM but not Microsoft Visio 2010 RTM or the SharePoint Designer 2010. The setup errors: Setup is unable to

Handling empty fields during SSIS CSV import

21 May, 2010 Roel van Lisdonk 0 Comments 1 category

Just a reminder: If you have a CSV file containing the data: DataInColumn1Row1,DataInColumn2Row1,DataInColumn3Row1 ,DataInColumn2Row2,DataInColumn3Row2 DataInColumn1Row3,DataInColumn2Row3, DataInColumn1Row4,,DataInColumn3Row4 and you import the columns using a SSIS package the empty columns will be converted to an empty string

How to create a windows explorer shortcut on the desktop to a SharePoint document library

21 May, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to create a shortcut on you’re desktop to a SharePoint document library, follow the steps on: http://www.endusersharepoint.com/2008/02/13/endusersharepointcom-update-on-creating-a-desktop-shortcut-to-a-sharepoint-library/ This will create a shortcut with a target formated like: "\\MySharePointSite.MyDomain.nl\DavWWWRoot\Site1\SubSite1\Shared Documents" MySharePointSite.MyDomain.nl =

Unit testing SSIS 2008 expressions

21 May, 2010 Roel van Lisdonk 0 Comments 1 category

In Microsoft SQL Server 2008 Integration Services, you can use expressions, see (Integration Services Expression Concepts, http://technet.microsoft.com/en-us/library/ms141827.aspx) in your dataflow tasks. For instance, if you want to import a flat file containing 2 columns: FirstName

Difference between PowerPivot Field List and the PivotTable Field List in Excel 2010

18 May, 2010 Roel van Lisdonk 0 Comments 1 category

When you are using PowerPivot in Excel 2010 there are two field lists: PowerPivot Field List Used for PowerPivot charts and tables Click on a PowerPivot chart or tables then on the ribbon >

Create you’re first Microsoft PowerPivot report based on the Microsoft AdventureWorks sample databases

12 May, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to get started with PowerPivot, you will need to install Microsoft Office 2010 and a separate Excel Add-in: PowerPivot for Microsoft Excel PowerPivot for Microsoft® Excel X86 Executable (32 bit) PowerPivot for

How to enable https on Microsoft SharePoint Server 2010 RTM by configuring alternate access mappings

10 May, 2010 Roel van Lisdonk 0 Comments 1 category

Open the Microsoft SharePoint Server 2010 Central Administration > System Settings > Configure alternate access mappings: Add Internal URLs Enter https://youreservername and choose intranet zone, click on ok Result Start inetmgr right click

Install a development Microsoft SharePoint 2010 RTM Server with PowerPivot and Microsoft SQL Server R2 Reporting Services integration

6 May, 2010 Roel van Lisdonk 5 Comments 1 category

These are the steps I followed to install a development Microsoft SharePoint 2010 server with PowerPivot and Reporting Services integration. I installed Microsoft SharePoint Server 2010 by following the steps on: http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint Then

Links on Managed self-service BI – PowerPivot and Corporate BI

5 May, 2010 Roel van Lisdonk 0 Comments 1 category

Some useful links on Managed self-service BI – PowerPivot and Corporate BI: General http://msdn.microsoft.com/en-us/library/ff628113.aspx http://powerpivotfaq.com http://powerpivotpro.com http://powerpivot-info.com DAX and time intelligence functions http://blogs.msdn.com/powerpivot/archive/2010/04/12/time-intelligence-functions-in-dax.aspx http://blogs.msdn.com/powerpivot/archive/2010/04/05/dax-data-analysis-expressions-measures-in-powerpivot.aspx http://powerpivot-info.com/post/56-introducing-powerpivot-dax-measures Datasets http://pinpoint.microsoft.com/en-US/Dallas http://developer.netflix.com/ Kasper de Jonge (colleague)

Month: May 2010