Importing DB2 (AS400) data to SQL Server using SSIS

Problem
While 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 from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component’s locale ID will be used.


(Figure 1)

Solution
After some research, the common answer is to set the “AlwaysUseDefaultCodePage” option to true. However, I have no idea where it can be set until I found the following posts:
http://www.ureader.com/msg/1251386.aspx
http://msdn.microsoft.com/en-us/library/aa705760(BTS.10).aspx

The Steps

  1. In the Data Flow Task Design surface, add a new OLE DB Source or OLE DB Destination for use with the Microsoft OLE DB Provider.
  2. Right-click the OLE DB source or destination object, and then click Show Advanced Editor…(Figure 2).
  3. On the Advanced Editor screen, click the Component Properties page.
  4. Set AlwaysUseDefaultCodePage to True (Figure 3).
  5. Click OK.
(Figure 2)

(Figure 3)

Spread the word. Share this post!

Leave A Reply

Your email address will not be published. Required fields are marked *