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

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