title: How to transfer data using SSIS when database columns are defined as VARCHAR(MAX)?
body: <p>I am getting the below message while executing a package.</p>
  
  <blockquote>
    <p>Text was truncated or one or more characters had no match in the target code page.</p>
  </blockquote>
  
  <p>I am taking data from an SQL table which has a field names <code>task_teammember</code> with the data type <code>VARCHAR(MAX)</code>. The package exeuction fails at the source. I type casted the column <code>task_teammber</code> into <em><code>VARCHAR(8000)</code></em> which executes the package without any error message. However, the destination receives only <strong>8000</strong> characters whereas there are more than <strong>8000</strong> characters in the source table.</p>
  
  <p>How do I transfer all the data from source to destination tables using SSIS when the columns are defined as <code>VARCHAR(MAX)</code>?</p>