SQL Server, when you import a flat data source, it is always truncated and an error solution cannot be executed
1 Typical error messages are as follows：
News
* ERROR 0XC02020A1: Data Flow task: Data conversion failed. The data Conversion of column "column 2" returns the status value 4 and state text text is truncated, or one or more characters do not have a match in the destination code page. ”。
(SQL Server Import and Export Wizard)
* ERROR 0XC020902A: Data Flow task: Output column column 2 (18) failed because of truncation, and an error occurred specifying truncation for the truncation row handling setting of Output column column 2 (18). A truncation error occurred on the specified object for the specified component.
(SQL Server Import and Export Wizard)
* ERROR 0xc0047038: Data Flow task: SSIS error code dts_e_primeoutputfailed. The PrimeOutput method of the component "source-11_txt" (1) returns the error code 0xc0202092. The component returned a failure code when the pipe engine called primeoutput (). Although the failure code is only relevant to the component, the error is fatal and the pipe has stopped executing. You may have previously issued an error message that provides detailed information about the failure.
(SQL Server Import and Export Wizard)
* ERROR 0XC0047021: Data Flow task: SSIS error code dts_e_threadfailed. The thread "SourceThread0" has exited with an error code of 0xc0047038. You may have previously issued an error message that provides detailed information about the reason for the thread exit.
(SQL Server Import and Export Wizard)
* ERROR 0xc0047039: Data Flow task: SSIS error code dts_e_threadcancelled. The thread "WorkThread0" received a shutdown signal and is terminating. The reason is that the user has requested a shutdown, or an error in another thread has caused the pipe to shut down. You may have previously issued an error message that provides detailed information about why the thread was canceled.
(SQL Server Import and Export Wizard)
2 fault Analysis: The reason is simple, the default flat file, the width of each field is 50,
If you have more fields than this in your flat data source, the above error will appear.
3 Solutions Also very simple, in the advanced, manually set the maximum allowable width of each field on the line, the screenshot is as follows:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
