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,36,SQL,QC_update,update_ytd_ABCDALY,,Executed 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?
LVL 2
jshesekAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jshesekConnect With a Mentor Author Commented:
Solved the problem.  
I imported it into Access again.  This showed a different import error.  Checked that record and it did have an extra | line in it.  Removed the pipe and it imported into SQL great.  So the problem was not row 12005 - but a different one.
0
 
lcohanDatabase AnalystCommented:
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?
0
 
jshesekAuthor Commented:
I solved the problem myself with Access
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.