title: Importing CSV in SSIS: truncation error
body: <p>I am importing a CSV file in SSIS having many string columns. I have set column width more than the maximum length, but still I am getting below errors</p>
  
  <blockquote>
    <p>[Input CSV File [114]] Error: Data conversion failed. The data
    conversion for column "Functionality" 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>[Input CSV File [114]] Error: The "Input CSV File.Outputs[Flat File
    Source Output].Columns[Functionality]" failed because truncation
    occurred, and the truncation row disposition on "Input CSV
    File.Outputs[Flat File Source Output].Columns[Functionality]"
    specifies failure on truncation. A truncation error occurred on the
    specified object of the specified component.</p>
    
    <p>[Input CSV File [114]] Error: An error occurred while processing file
    "D:\Prateek\SSIS_UB_PWS\January.csv" on data row 236.</p>
    
    <p>[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The
    PrimeOutput method on Input CSV File 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.</p>
  </blockquote>
  
  <p>As a work around, I have set values to 500 or 1000 and now it is allowing me to continue, but the actual length is in double digit.</p>
  
  <p>Kindly suggest what could be the possible error.</p>