April 8, 2013 at 6:22 am
Hi,
I am getting error while moving data from SSIS dataflow task using provider "IBM DB2 UDB for iseries IBMDASQL OLEDB provider" , it was running fine,suddenly starts failing I noticed that the rows that are failing contains symbols " – " called as endash having ANSI code 0150. This is stored in varchar field in SQL Server 2008R2, and is mapped to character data type column of AS400/DB2 database. but its failing with error "CWBZZ5014 Value of parameter columnName could not be converted to the host data type."."CWBNL0107 - Converted 80 bytes, 2 errors found beginning at offset 10 ".
AS I found that this special symbol is at 11th position in the given column.
I have tried changing force translation value from 65535 to 1252 (Win Latin-1) but its not working ?
Can someone help here.
Thanks,
April 8, 2013 at 6:28 am
What is the text of the error message?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 8, 2013 at 6:44 am
this is the error msg..
"CWBZZ5014 Value of parameter columnName could not be converted to the host data type."."CWBNL0107 - Converted 80 bytes, 2 errors found beginning at offset 10 ".
SQL server datatype is varchar and as400 columnname datatype is also character.
but since column contains a special character "–" which is "en dash" having ANSI value 150 supoorted by varchar in SQL Server.
so using provider "IBM DB2 UDB iseries OLEDB provider" ,convertion error is happening.
April 8, 2013 at 6:51 am
rajeshk 36156 (4/8/2013)
this is the error msg.."CWBZZ5014 Value of parameter columnName could not be converted to the host data type."."CWBNL0107 - Converted 80 bytes, 2 errors found beginning at offset 10 ".
SQL server datatype is varchar and as400 columnname datatype is also character.
but since column contains a special character "–" which is "en dash" having ANSI value 150 supoorted by varchar in SQL Server.
so using provider "IBM DB2 UDB iseries OLEDB provider" ,convertion error is happening.
I don't know the solution, because I don't know much about what DB2 supports. Do you need the endash, or could you replace it with a hyphen, perhaps? If you need the endash, I guess you'll have to find out how it should be stored in DB2 and do some sort of transformation.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply