21 May, 2010
0 Comments
1 category
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.
Tags: Integration Services
Category: Uncategorized