Data Conversion Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Data Conversion Error

Data Conversion Error

Rate Topic

Display Mode

Topic Options

Author

Message

chinni_16

Posted Monday, October 22, 2012 7:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, January 17, 2013 10:46 PM
Points: 33, Visits: 24

Hi!
I need to load a table of 35 million records on to a flat file .After loading 10 million records it gives an error
[Flat File Destination [112]] Error: Data conversion failed. The data conversion for column "FirstName" returned status value 4 and status text "Text was truncated or one or more character
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Flat File Destination" (112) failed with error code 0xC02020A0 while processing input "Flat File Destination Input" (113). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

On this particular field (it is a nvarchar) I am not doing any data conversion.
I am using data conversion only on a field of data type ntext.
I researched on google and tried different options
like setting the particular field to ignore error and another suggestion to go to advanced editor and set the error row to ignorefailure in output columns.

Thank you

Post #1375432

Koen Verbeeck

Posted Tuesday, October 23, 2012 12:29 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

What datatype has the FirstName column in SSIS? And especially, what length?
And what is the datatype in the destination? Check the flat file connection manager to find out.

What is the encoding of the flat file?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1375846

subbareddy542

Posted Tuesday, October 23, 2012 12:30 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:17 AM
Points: 832, Visits: 613

PLS try below mentioned steps:
(1) go to flat file show advance advisor .
(2) go to input and output columns
(3) go to filat file sorce output--> output columns
after which column your try to convert nvarchar to ntext
that column length change it...

Post #1375847

« Prev Topic | Next Topic »

Permissions