Handling empty fields during SSIS CSV import

0 Comments

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

0 Comments

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

0 Comments

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

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

5 Comments

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

0 Comments

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)