Solved

SQL Import Job Failed Code: 0xC0202092  & Code: 0xC0047038

Posted on 2012-03-20
3
1,806 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:jshesek
  • 2
3 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 37744749
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
 
LVL 1

Accepted Solution

by:
jshesek earned 0 total points
ID: 37748034
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
 
LVL 1

Author Closing Comment

by:jshesek
ID: 37764947
I solved the problem myself with Access
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
The duplicate key value is (<NULL>) 14 46
SQl query 19 14
BULK LOGGED - log full 9 15
Change part of a string 2 24
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now