Home > IT Answers > AS/400 > Problem with SSIS & AS400, Source is AS400, Dest is SQL2005
Thuybui
35 pts.
 Problem with SSIS & AS400, Source is AS400, Dest is SQL2005
AS/400 errors, SQL 2005, SSIS
When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

Software/Hardware used:
ASKED: June 24, 2008  11:44 PM
UPDATED: April 29, 2010  1:59 PM
RELATED QUESTIONS
Answer Wiki:
Are you columns in the destination of the correct data type, and are they long enough? You may need to run the data transformation through a "Data Conversion" Data Flow Transformation so that you can map the AS/400 data type to a known SQL data type manually. When doing so don't forget to set the column sizes wide enough for your text data. I don't think the problem is the size. I do use "Data Conversion" and increased the size from 50 to 500 for that particular column. I think the problem is SSIS cannot convert some data in that column using the default code page of 1252. It worked fine in DTS but it is not working correctly in SSIS? Thanks
Last Wiki Answer Submitted:  June 25, 2008  3:47 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.
 

Without knowing what code page (CCSID) you’re converting from and what data you’re converting, no one can tell you anything useful. It’s like asking “What kind of box do I need to put my stuff in? A box 2′ wide, 2′ deep and 1′ tall doesn’t work right.”

Tom

TomLiotta
 108,330 pts.
 

Use the Display File Field Description (DSPFFD) command against the table/file. Review the display and record the various Coded Character Set Identifier (CCSID) values shown for the columns you are selecting. Get back to us with each of the unique CCSID values that you found.

With that information we could then recommend an appropriate Windows code page.

bvining
 6,055 pts.