SQL Server imports flat File source data, error 0XC02020A1 error 0xc020902a error 0xc02020c5, return status value 4 and status text "text truncated, or one or more characters in the target code page ...

When using SQL Server to import flat File source data, error 0XC02020A1: Error 0xc020902a: Error 0xc02020c5; Error 0xc0047022: Return status value 4 and status text "text is Truncation, or one or more characters that do not have a match in the target code page.

Error 0XC02020A1: Data Flow Task 1: Data conversion failed. The Data Transformation of column "column 6" returns the status value 4 and the status text "text is truncated, or one or more characters do not have a match in the target code page." ”。 (SQL Server Import and Export Wizard) Error 0XC020902A: Data Flow Task 1: "Output column" column 6 "(34)" failed due to truncation, and an error occurred specifying truncation for truncated row processing settings for "Output column" column 6 "(34)". A truncation error occurred on the specified object for the specified component. (SQL Server Import and Export Wizard) Error 0XC02020C5: Data Flow Task 1: Conversion failed when column "column 6" (34) is converted to column "column 6" (70). The conversion operation returns a status value of 4 and the status text "text is truncated, or one or more characters do not have a match in the target code page." ”。 (SQL Server Import and Export Wizard) Error 0xc0047022: Data Flow task 1:ssis error code dts_e_processinputfailed. When processing the input Data transformation Input (63), the ProcessInput method of the component "Data conversion 0-0" (62) failed with an error code of 0xC020902A. This component of the identity returned an error from the ProcessInput method. Although the error is unique to this component, it is fatal and will cause the data Flow task to stop running. An error message may have been issued before, providing more information about the failure. (SQL Server Import and Export Wizard)

This error often occurs when there are some outliers in the imported data (or, for the database software, a wrong value), an error that cannot be converted, or truncated.

One approach is to find this outlier, which is not feasible when the amount of data is large. For example, the author of this import data is more than a million, not to open the file to find the wrong value. Sometimes because the allocated data is not wide enough (by default, 50), it increases. When it is a data conversion problem, the increase is useless, in addition, for an outlier, all the basic type length is changed, not necessary.

The second approach, for this small amount of data outliers, ignores it. that is, when an outlier occurs, it is not an error to exit the import data process, but to ignore this small exception point.

Operation Steps:

, select the file you want to import

Select advanced options on the left

Then, change the DataType of a column to a non-default value (you can see the options shown in the last picture when you repeat the import again after the import error)

Click Next and3 times you will see such as:

If a truncation error has occurred just now, select the option to ignore.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQL Server imports flat File source data, error 0XC02020A1 error 0xc020902a error 0xc02020c5, return status value 4 and status text "text truncated, or one or more characters in the target code page ...