Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

35 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,130 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • bvining
    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.
    6,495 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following