SQLTeam.com | Weblogs | Forums

Data Conversion



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


How are you loading the data?


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?