title: What SSIS "error code 0xC0202092" means? (DTS_E_PRIMEOUTPUTFAILED)
body: <p>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...)</p>
  
  <p>[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.".</p>
  
  <p>[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.</p>
  
  <p>[Flat File Source [170]] Error: An error occurred while processing file "G:\Share\Nationwide Charities Listing.csv" on data row 120.</p>
  
  <p>[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.<br>
  The PrimeOutput method on component "Flat File Source" (170) returned error code 0xC0202092.<br>
  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.<br>
  There may be error messages posted before this with more information about the failure.</p>