Blog on software engineering
Handling empty fields during SSIS CSV import

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.

This site uses Akismet to reduce spam. Learn how your comment data is processed.