FIX: The import of host data that contains Arabic characters is not successful when you use Microsoft OLE DB Provider for DB2 in a Host Integration Server 2009 environment

Applies to: Host Integration Server 2009

Symptoms


In a Microsoft Host Integration Server 2009 environment, you use Microsoft OLE DB Provider for DB2. You try to import host data by using the SQL Server Integration Services Import Wizard from the Microsoft SQL Server Management Studio to an SQL database. When the host data contains Arabic characters, the import is not successful. Additionally, you receive the following error message:
Error 0xc020901c: Data Flow Task: There was an error with output column "COLUMN1" on output "COLUMN2".

The column status returned was: "The value could not be converted because of a potential loss of data."

Resolution


The hotfix that resolves this issue is included in cumulative update package 1 for Host Integration Server 2009.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2587090 Cumulative update package 1 for Host Integration Server 2009

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.