title: Issue converting NTEXT & nvarchar(255) to nvarchar(max)
body: <p>How can I convert an NTEXT column to NVARCHAR(MAX)?</p>
  
  <p>I have 4 databases in which there is a table that exists in all four. Inside of this table there exists a <code>Notes</code> column of type <code>NTEXT</code> <em>except</em> in one database where that column is <code>nvarchar(255)</code>.</p>
  
  <p>So:</p>
  
  <ul>
  <li>3 <code>NTEXT</code></li>
  <li>1 <code>nvarchar(255)</code></li>
  </ul>
  
  <p>My ETL takes data from these four tables and puts them into one table where the <code>Notes</code> column is of type <code>nvarchar(max)</code>.</p>
  
  <p>I didn't realize that one column was <code>nvarchar(255)</code> until my ETL didn't work because all four tables are supposed to be identical in structure.</p>
  
  <p><strong>Error:</strong></p>
  
  <blockquote>
    <p>[Source DB [25]] Error: There was an error with Source 
    DB.Outputs[OLE DB Source Output].Columns[Notes] on Source 
    DB.Outputs[OLE DB Source Output]. The column status returned was:
    "DBSTATUS_UNAVAILABLE".</p>
  </blockquote>
  
  <p>I'm guessing this is the issue since the error wasn't specific. How can I convert this column to <code>nvarchar(max)</code>?</p>