title: SSIS Access to SQL. Binding error: The binding status was "DT_NTEXT"
body: <p>I am trying to get an <strong>SSIS</strong> package inherited from a previous colleague to execute. The package pulls from an <strong>Access</strong> database and then puts the data into an <strong>SQL</strong> database.</p>
  
  <p>One of the fields, let's call it 'Recommendations' is of the type <strong>'memo'</strong> in the Access database. The column in the SQL output database is of the type <strong>varchar(max).</strong></p>
  
  <blockquote>
    <p>Error: 0xC002F446 at Data Flow Task, OLE DB Destination [218]: An error occurred while setting up a binding for the "Recommendations" column. The binding status was "DT_NTEXT". The data flow column type is "DBBINDSTATUS_UNSUPPORTEDCONVERSION". The conversion from the OLE DB type of "DBTYPE_IUNKNOWN" to the destination column type of "DBTYPE_WVARCHAR" might not be supported by this provider.</p>
  </blockquote>
  
  <p>What confused me further is that a different column of type <strong>memo</strong>, which is also processed as <strong>DT_NTEXT</strong>, and is also placed into a <strong>varchar(max)</strong> data type in the SQL db, does not throw an error message. I have tried numerous conversion object types but have yet to successfully execute the package.</p>