Monthly Archives: November 2009

Importing DB2 (AS400) data to SQL Server using SSIS

ProblemWhile setting up the SQL Server Integration Services (SSIS) to import data from a DB2(AS400) database to SQL server, I have received such error (Figure 1): Warning at {[GUID]} [OLE DB Source[[Source ID]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the “DefaultCodePage” property, the code page […]

Read More