Data Conversion

SSIS and Import/Export
1

Hi,

I am tring to pull data from SAP Server and load into sql server and getting error. Please help

[Data Conversion [304]] Error: Data conversion failed while converting column "PMT_CAT_CODE" (202) to column "Copy of PMT_CAT_CODE" (716). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

Thank You

2

How are you loading the data?

3

What is the Datatype and Width of the [PMT_CAT_CODE] and [Copy of PMT_CAT_CODE] columns, and also what is the Collation of them?

If you make them the same then I expect the problem will go away - although it would raise some question in my mind:

  1. Why are the columns different?
  2. What other columns are also different?