January 20, 2010 at 12:52 pm
hello SS people,
I am brand new at this stuff and cannot find exactly how to proceed, so please be explicit with any instructions.
We need to update an existing SSDB table nightly and I thought using the import task through an ODBC with the AS400 would work (I actually want to set up an SSIS to do the work once it works) and it looked like it was working until I got to record 152314 when I encountered this error:
Error 0xc020901c: Data Flow Task: There was an error with output column "CDGRTR" (41) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
I tried changing the receiveing table's data type...no good.
I have no idea how to change the target code page and I don't know how to ignor truncation.
And strangely, I can import this table into Access and use the update command with the source table exported as a .txt file. Go figure?
January 21, 2010 at 7:36 am
If you right-click on your source and go into the Advanced Editor you can set the code page to be used. I'd try that.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 21, 2010 at 8:33 am
Hi,
I have come across this before and spent ages working on it ..may not be exact but see what we can do
The issue i had was that the original import was set to import 30 varchar and then someone decided to provide data that was longer then this.
So work out what column 11 is and then if you do a len on that and sort ascending that should give you the max size of the column. ( use access and this should work as well)
IN SSIS you will have your source object and your destination object if you double click on the green line and then click metadata , you can see the length of the field as originally defined..if this is less then the maximum size then you will need to recreate the data flow and obv check your database table also..
Hope this helps...
Regards
Ray
January 22, 2010 at 9:19 am
Thanks for your insight.
It's a funky character issue comming out of the AS400 side. Now I need to determine which code sheet will provide a reasonable translation. But thanks to you both, I know where to make that change. Many thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply