Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Error: An error occurred while skipping data rows

Tags:

ssis-2012

I am getting these errors in flat file connection manager.

Error: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202091. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

I am reletively new to ssis and I am finding it quite hard to figure out the issue. Please let me know your views.

like image 369
Allen Jose Avatar asked Sep 05 '14 12:09

Allen Jose


1 Answers

On your flat file connection properties - Look for the property "AlwaysCheckForRowDelimeters" - SET it to FALSE.

Hope that helps.

like image 105
desoxx Avatar answered Sep 26 '22 12:09

desoxx