All geek questions in one place

DTS_E_PRIMEOUTPUTFAILED with error code 0xC0202091 when loading a flat file

I get an error when I try to start my SSIS Package , the error is:

[Flat source file [1]] Error: The column delimiter for column "Column" 8 "was not found.

[Flat source file [1]] Error: A line error occurred while skipping data.

[SSIS.Pipeline] Error: SSIS error code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on the Flat Source File component (1) returned error code 0xC0202091. The component returned a failure code when called PrimeOutput (). The meaning of the failure code is determined by the component, but the error is fatal, and the pipeline has stopped executing. Prior to this, error messages may appear with additional information about the failure.

Most csv load without problems, but several csv do not even exist before the package works fine for many years.

+6
source share
4 answers

This error was also detected, it turned out that it skips rows of data, because there are no columns in my CSV file. Try checking the correct columns in your file.

+7
source

I also encountered the same error. However, I decided to fix it by checking the sources of the files. Make sure that there are no extra spaces, check the separator, for example, a comma, etc., And also the data entry should be synchronized with the first line. Hope this helps you.

+1
source

Another possible source of this error is that you created your system with a new version of the incoming file, and then go back to import the old ones and find the error ... check that all the fields are there! I found that for several days “back” three fields were missing, causing this error.

0
source

I found in our FTP configuration old files may hang in SAN or FTP, and this may also cause this error. Very frustrating.

0
source

Source: https://habr.com/ru/post/944979/

More articles:


All Articles