Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 moving data from SSIS to As400 using IBM DB2 oledb
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

RK_G
Starting Member

India
1 Posts

Posted - 04/08/2013 :  05:18:55  Show Profile  Reply with Quote
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,
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000