DSXchange

When I try to read a field with a NULL value from DB2 running on an AS400. The staging table which exists in SQL Server populates the field with garbage data, looks like a hex value. Has anyone experienced this before and what was their work around?

I had worked with DB2 before and never had this sort for problem while reading null values. Try to create a simple job and read the null value and insert into your staging table. Check the data type in both source and target table and make sure there isn't any transform happing to that column inside the job.

Thanks
Rasi