Handling empty fields during SSIS CSV import

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 (“”) and not NULL.

Leave a Reply

Your email address will not be published. Required fields are marked *