Custom error pages in ASP .NET 4.0

0 Comments

If you want to use a custom error page in ASP .NET and want to show the exception details on that page, you must save the Server.GetLastError to a sessions variable in the Global.asax Application_Error

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