What SSIS "error code 0xC0202092" means? (DTS_E_PRIMEOUTPUTFAILED)

sql-server csv ssis import-from-csv
Virgil_R picture Virgil_R · Mar 4, 2015 · Viewed 35.2k times · Source

Here it is below a full dump of the SSIS complains. Please note that I imported the same data in the destination table by using a different tool already and everything is looking perfectly, I suppose that means the schema of the destination table is correct. What do I have to do here to actually use SSIS (the entire process is automated, I did it manually now but that is not acceptable in long term...)

[Flat File Source [170]] Error: Data conversion failed. The data conversion for column "City" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

[Flat File Source [170]] Error: The "output column "City" (203)" failed because truncation occurred, and the truncation row disposition on "output column "City" (203)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

[Flat File Source [170]] Error: An error occurred while processing file "G:\Share\Nationwide Charities Listing.csv" on data row 120.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "Flat File Source" (170) returned error code 0xC0202092.
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.

Answer

hammadmirza picture hammadmirza · Mar 4, 2015

Your data contains unicode characters i guess and the destination is varchar(23). Try to change it to nvarchar(23) and then import ?

Related questions

SSIS: Code page goes back to 65001

In an SSIS package that I'm writing, I have a CSV file as a source. On the Connection Manager General page, it has 65001 as the Code page (I was testing something). Unicode is not checked. The columns map to a …

Read More
SSIS is executing successfully, but it doesn't seem to be running the script task portion

I have an SSIS package that runs an SQL query and exports it to a csv file via a Data Flow Task. After the csv is created, I have a "Script Task" set to connect to an SMTP server and …

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More