Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data Conversion Error Expand / Collapse
Posted Monday, October 22, 2012 7:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 14, 2015 10:28 AM
Points: 33, Visits: 25
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
Posted Tuesday, October 23, 2012 12:29 AM



Group: General Forum Members
Last Login: Friday, February 5, 2016 2:07 PM
Points: 15,016, Visits: 12,988
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1375846
Posted Tuesday, October 23, 2012 12:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 25, 2015 1:02 AM
Points: 938, Visits: 689
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 »

Add to briefcase

Permissions Expand / Collapse