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

  • 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