DSXchange

Just try mapping all the columns to dataset without any transformation done , and check whether now the data is still with '********'

May be the Conversion that you have done is wrong , or format is wrong(like you have convertd into a Timestamp and in metadata definition you have given Date) . these are the scenarios where Data appears '**********' in Dataset. if this is not the case then Data is wrong.please filter properly.

Why dont you use ' STRIP(CHAR(VARIABLE NAME)) ' when you get the data from DB2 database itself , so that the trim works for you in your case