Loading from DB2 to Teradata with SSIS 2012 converts content with special characters ("zero characters") to NULL.

• gopeep

  SSC Enthusiast

  Points: 139

  More actions

  March 27, 2015 at 1:09 pm

  #295493

  Loading from DB2 to Teradata with SSIS 2012 converts content with special characters ("zero characters") to NULL.

  When I hit PREVIEW in SSIS DB2 OLE DB Source component, I can see the data correctly but when I load it into some destination file or database table, the content will be lost. NULL. Other rows are OK but the ones with some special characters will get lost.

  

  How to fix this? How to load correctly from DB2 with SQL Server Integration Services?

  I have tried Microsoft OLEDB driver for DB2 and also IBM OLEDB provider for DB2, they both have the same issue.