JS List
asked on
SQL Import Job Failed Code: 0xC0202092 & Code: 0xC0047038
There's an import job in SSMS (SQL 2008 R2). It creates a new table and imports a pipeline delimited text field into it.
Here's the error info.
03/20/2012 08:59:24,QC_update,Error,3 6,SQL,QC_u pdate,upda te_ytd_ABC DALY,,Exec uted as user: XXX\SQLUPLOADS. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:59:24 AM Error: 2012-03-20 08:59:51.47
Code: 0xC02020A1
Source: Data Flow Task Source - ABCTD_txt [1]
Description: Data conversion failed. The data conversion for column "Column 26" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". End Error
Error: 2012-03-20 08:59:51.47
Code: 0xC020902A
Source: Data Flow Task Source - ABCTD_txt [1]
Description: The "output column "Column 26" (114)" failed because truncation occurred<c/> and the truncation row disposition on "output column "Column 26" (114)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2012-03-20 08:59:51.47
Code: 0xC0202092
Source: Data Flow Task Source - ABCTD_txt [1]
Description: An error occurred while processing file "ABCTD.txt" on data row 12005. End Error
Error: 2012-03-20 08:59:51.47
Code: 0xC0047038
Source: Data Flow Task SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - ABCTD_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component<c/> but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
End Error
DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:59:24 AM Finished: 8:59:58 AM Elapsed: 33.15 seconds. The package execution failed. The step failed.,00:00:34,0,0,,,,0
Column 26 is the last column. I checked the file in Textpad & NotePad++ The end | is in the same column (1701) as the previous entries.
Any ideas?
Here's the error info.
03/20/2012 08:59:24,QC_update,Error,3
Code: 0xC02020A1
Source: Data Flow Task Source - ABCTD_txt [1]
Description: Data conversion failed. The data conversion for column "Column 26" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". End Error
Error: 2012-03-20 08:59:51.47
Code: 0xC020902A
Source: Data Flow Task Source - ABCTD_txt [1]
Description: The "output column "Column 26" (114)" failed because truncation occurred<c/> and the truncation row disposition on "output column "Column 26" (114)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2012-03-20 08:59:51.47
Code: 0xC0202092
Source: Data Flow Task Source - ABCTD_txt [1]
Description: An error occurred while processing file "ABCTD.txt" on data row 12005. End Error
Error: 2012-03-20 08:59:51.47
Code: 0xC0047038
Source: Data Flow Task SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - ABCTD_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component<c/> but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
End Error
DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:59:24 AM Finished: 8:59:58 AM Elapsed: 33.15 seconds. The package execution failed. The step failed.,00:00:34,0,0,,,,0
Column 26 is the last column. I checked the file in Textpad & NotePad++ The end | is in the same column (1701) as the previous entries.
Any ideas?
I would check the import text file to see what is it on ""ABCTD.txt" on data row 12005" as per above error. It may be some missing EOL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I solved the problem myself with Access