Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ying Zhang How to Handle NULL Values Loaded by SSIS from Excel Files RE: How to Handle NULL Values Loaded by SSIS from Excel Files
rajgadiraju
SSC Enthusiast
Points: 117
More actions
June 16, 2009 at 10:10 am
#1010314
Another way is to add a "Derived Column Transform" and use the expression "?" with a default value that replaces null.
Example: ISNULL([testColumn])?0:[testColumn]
Raj