[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-03-20
3
Medium Priority
?
2,163 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 40

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 2

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 2

Author Closing Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

867 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