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