Alex, It's likely a field length issue, since you have your strings as length of -1 from the excel file. Please provide the complete sql script (create table, insert data, query).
To resolve this error, change the field size. One or more columns in your text file have larger column sixe than the target Data Truncation (Int32, Boolean, Boolean, Int32, Int32) Creates the DataTruncation object. Recreate/modify the SQL Server tables to use the appropriate Unicode supporting types, e. 1 upgrade (first modify to binary type and then back to string type with characterset utf8). The data conversion for column “ColumnName” returned status value 4 and status text “Text was truncated or one or more characters had no match in the target code page.
Error: 0xC020902A at Data Flow Task, DataReader Source : The "component "DataReader Source" (575)" failed because truncation occurred, and the truncation row disposition on "output column "REPORT_PART_NUMBER" (789)" specifies failure on truncation.When I run it in BIDS 2008r2 it runs just fine, no truncation issues at all. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. Sql data truncation error You may want to send a donation instead.
0 kommentar(er)
