title: How to overcome truncation error?
body: <p>I am trying to use the import and export wizard to move a small data set from a CSV file to an existing (empty) table.  I did Script Table As > Create To, to get all DML for this table.  I know the field type of the two fields which are causing problems is varchar(50).  I'm getting this error message:</p>
  
  <pre><code>Error 0xc020902a: Data Flow Task 1: The "Source - Reconciliation_dbo_agg_boc_consolidated_csv.Outputs[Flat File Source Output].Columns["ReportScope"]" failed because truncation occurred, and the truncation row disposition on "Source - Reconciliation_dbo_agg_boc_consolidated_csv.Outputs[Flat File Source Output].Columns["ReportScope"]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
   (SQL Server Import and Export Wizard)
  </code></pre>
  
  <p>The max length of all characters is 49, so I'm not sure why SQL Server is complaining about truncation.  Is there any way to disable this error check and just force it to work?  It should work as-is!  Thanks everyone.</p>