Replace blanks in excel file by 0

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  April 12, 2010 at 8:40 am

  #221141

  Hi,

  I have an Excel file with Quaterly sales figures. Some fields in sales figures are blanks indicating no sales for particular quarter for specific product.

  using SSIS how can i replace NULL by 0 so that i can aggregate and obtain the Sum of Total sales and further create a Pivot Chart

  Raunak J

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  April 13, 2010 at 6:30 am

  #1150652

  Add a derived column transformation with the following expression:

  (ISNULL(myColumn)) ? 0 : myColumn

  Do this for every column that needs conversion.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP