title: SSIS avoid changing derived column expression manually
body: <p>I have an SSIS package which needs to run every first day of the week, source is from excel file and the destination is SQL table.</p>
  
  <p>The current process is to replace the null value to 0 of excel file manually, (it takes a lot of time), so I have created a package and currently working  with derived column expression "(Column1 == "" ? 0 : Column1)", but the excel file columns are not always the same to the derived column expression so every time I have to run the package I also have to edit the derived column expression. I'm looking for a better way to do this, and to avoid doing it manually. Thanks in advance.</p>