October 22, 2012 at 7:54 am
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
October 23, 2012 at 12:29 am
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 23, 2012 at 12:30 am
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...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply