DTS Job Urgent

Hi All,
SQL Server 7
Is their anyway to replace null values in all the fields being replicated to blanks in a DTS Job?
Waiting for reply
TIA
AdilYou can either have a staging table(and update the nulls) or use the activex script task and test for null and set that field to ''.|||In dts:

if IsNull(DTSSource("ghi")) then
DTSDestination("ghi") = ""
else
DTSDestination("ghi") = DTSSource("ghi")
end if