Importing CHAR() fields containing null values from DB2 to SQL Server via SSIS

Earlier this year, I was working with a customer who was doing a mainframe migration from DB2 to SQL Server, and they were using SSIS to import the tables. Several of their columns were CHAR data types, with a null byte as the first byte of the field. The columns, when imported, all contained empty…

1