title: how to load varchar(max) value into mysql server using ssis package
body: <p>I have one question in ssis
  how to load sql server  <code>VARCHAR(MAX)</code> data type column related data into mysql server table using ssis package</p>
  <p>source : product table ( ms sql server )</p>
  <pre><code>pid (int)  | productDescrption (varchar(max))
  </code></pre>
  <p>Destination : product  table (mysql server )</p>
  <pre><code>Pid ( int)   | productDescription ( dt_ntext)
  </code></pre>
  <ol>
  <li>step1: drag and drop oledb source and configure the SQL Server table product</li>
  <li>step2: change data conversion for <code>productdescription</code> <code>varchar(max)</code> to <code>dt_next</code></li>
  <li>step3: configure the destination odbc destination for MySQL product table (here odbc 32 bit driver is installed) and i I ran the package that tim i got error like below:</li>
  </ol>
  <blockquote>
  <p>[ODBC Destination [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HYC00'. Native Error Code: 0. [MySQL][ODBC 5.2(w) Driver][mysqld-5.7.24-log]Parameter arrays with data at execution are not supported</p>
  <p>[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component &quot;ODBC Destination&quot; (2) failed with error code 0x80004005 while processing input &quot;ODBC Destination Input&quot; (13). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.</p>
  </blockquote>
  <p>Can you please tell me how to achieve this task in ssis</p>