Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source 1 returned error code 0xC0202091

Question

I am loading CSV from my local machine to to load the data to database table using SSIS process. I am getting the below error while loading. One my colleague is doing the same process, it works as expected for him. can someone help me with this?

[Flat File Source [175]] Error: An error occurred while skipping data rows.
*****[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source 1 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.*****

kindly let me know if you find solution

Answer 1

Hi @Naveen Narasingh ,

Please check that if the flat file source has been modified or not.

Clicking Reset Columns in the connection manager for the file for a try.

Also try to re-add the connection manager and make sure the TextQualifier is correct.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Zoehui,

Thank you so much for the response. I have verified all the mentioned options but no luck.

My delimiter is "¬¬". (actual data with delimiter: DOCID¬¬DOCTYPE¬¬ARCHIVE_DATE¬¬),

torage/temp/219403-image.png

Laptop OS: Windows 11
Visual Studio Version :
Microsoft Visual Studio Community 2019
Version 16.11.16
SSIS Version: 1326005

Answer 3

Hi @Naveen Narasingh ,

With the data you provided, I could not re-produce the issue.

As you said that your colleague could create the package successfully, have you check the release of the VS with his?

Or you may try to repair the VS with installer or download the VS2017 to see if the issue is related with the tool.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Hi @ZoeHui-MSFT ,

I tried to install Visual Studio 2017 with SSIS but I am getting the same error message. I tried to raise a support ticket as well with Microsoft but I don't have a support plan available.
Can you please help to resolve this issue?

Thanks
Naveen