I'm importing data from as400 to sql 2005 using ibm db2 udb for iseries ibmda400 ole db provider. My problem is when users copy and paste text from email in outlook using html and paste it in the green screen, some type of formatting character is inserted also. The 400 ignores it but as I'm importing the data to the sql server it errors with error below.
Error 0xc020901c: Data Flow Task: There was an error with output column "DOMNOTES" (17) 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.".