I do not work with DB2 much and am not sure how great the driver is or how well the engine reports its own metadata when SSIS asks. Does DB2 have something analogous to CAST or CONVERT? You may want to try casting that column on the initial retrieval. SSIS is detecting the column as DT_STR but it seems you're getting data outside that domain from DB2 CHARACTER.