Replace null values with zero using SSIS
Step 1: Drag and drop Data flow task to control flow tab and edit Step 2: Take excel data source Create new excel connection Browse source file from local syatem Select sheet name Click preview and see few null values in TaxAmt column Step 3: Drag and drop derived column and replace TaxAmt column Method 1: Syntax for expression is ISNULL(TaxAmt) ? 0 : TaxAmt Method 2: REPLACENULL(TaxAmt,0) Step 4: Execute task