[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2012-03-20
3
Medium Priority
?
2,115 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

650 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