If you encounter issues importing a CSV file using an SSIS package—particularly when strings are enclosed in double quotes—here’s a method you can try to fix the problem.
Sample CSV Data
"090","Grey","" "091","Grey, Red","" "092","White/Teal","" "042","Blue ","(\"is not blue\" )" --- TextQualified '"' with single quote inside value "093","Light Grey",""
Error Message:
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202092. This error is fatal and stops pipeline execution. Additional error details might be available earlier in the log.
To fix this, review the column settings in the Flat File Connection Manager:
Steps:
Navigate to Flat File Connection Manager → Advanced Tab and review the column properties.
Set TextQualified to false.
Now, attempt to import the CSV file again. The issue should be resolved.
