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 ] 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.