Error: An error occurred while skipping data rows

ssis-2012
Allen Jose picture Allen Jose · Sep 5, 2014 · Viewed 31.6k times · Source

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.

Answer

desoxx picture desoxx · Aug 17, 2016

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

Hope that helps.

Related questions

Error: 0xC0202009 at Data Flow Task, OLE DB Destination [43]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image) I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get a …

Read More
SSIS Package not wanting to fetch metadata of temporary table

I have an SSIS Package, which contains multiple flows. Each flow is responsible for creating a "staging" table, which gets filled up after creation. These tables are global temporary tables. I added 1 extra flow (I did not make the package) …

Read More
SSIS - How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename

Any help is much appreciated. I am trying to create an SSIS package to loop through files in the folder and get the Path + filename and finally execute the stored proc with parameter as path+filename. I am not sure …

Read More