title: ssis replace null with empty string
body: <p>I am using conditional split on SSIS and I am getting errors as some of the rows contain NULL values. I know this can be changed by using the Derived Column and the REPLACENULL function. However, my table has about 200 columns and this would be very tedious to carry out.</p>
  
  <p>I was wondering if there is anything I can do using Script Component which would loop through all the rows and change any NULLS to an empty string?</p>