Solved

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

Posted on 2012-03-20
3
1,940 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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
TSQL remove duplicates from different columns 14 50
T-SQL: Wrong Result 7 34
sql server string_split 4 22
Delete duplicates from SQL Server table 2 19
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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 ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

738 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