Getting code page errors....

Hot Topic

Reporting Services Error
ODBC & Multi-threading
Slow XML value() calls
Returning last months data
How to run SSIS package
db design question
Invalid Data Type error with Subreports
How to run package with variables using dtexec?
Capturing Processing Status and Progress Messages
SQL help

SQL Server

Database query performance
Beginning SSIS - Sharepoint and Excel
URGENT - sql express - can not setup database. why?
SQL License Questions and other questions >>>>
Cube corruption
Sorted Input
Convert SQL 2005 to SQL 2000
How to make republishing ?
Problem opening UDF
How to run parallely/sequentially

Getting code page errors....

I am importing some data from my IBM DB2 Z/OS mainframe to SQL Server 2005 using the SSIS import wizard. The wizard automatically converted the DB2 string data before trying to store it to SQL Server. The code page that the wizard chose to do its conversion is the 1252 Ansi Latin. However, I am getting the following error on the address field...."one or more characters had no match in the target code page". Can someone suggest another code page ASCII IBM 37

Answer this question

Getting code page errors....

  • swimming

    Can you determine the code page of your DB2 Host

    If you have characters in the source that have no match in your target code page you might
    have to replace them via the derived column transformation. Therefore you have to know
    all those characters that do not match.

    Fridtjof

  • Blair Stark

    Can anyone tell me why this would work with my old DTS but not in SSIS Both of which were created through wizards with no extra coding or transformations.
  • Getting code page errors....
Answer this question