Hi,
I having some truble importing a txt file in to SQL Server express 2008 R2 using the import Export Wizard.
The error occur in the executing stage:
- Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "CAPTION1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
Error 0xc020902a: Data Flow Task 1: The "output column "CAPTION1" (194)" failed because truncation occurred, and the truncation row disposition on "output column "CAPTION1" (194)" specifies failure on truncation. A truncation error occurred on the specified
object of the specified component.
(SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "E:\USA Data\Sept_2010_Res_Bus\bdfoutfinal_oneper.txt" on data row 70.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - bdfoutfinal_oneper_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput()
View Complete Post