title: Converting BlobColumn to String in SSIS Script Component
body: <p>How do I convert <code>BlobColumn</code> to <code>String</code> in <code>SSIS Script Component</code>.</p>
  
  <p><strong>E.G:</strong></p>
  
  <pre><code>Source Column : OrganisationProviderID NVARCHAR(MAX)
  
  Destination Column : OrganisationProviderID VARCHAR(20)
  </code></pre>
  
  <p>How can this be acheived in <code>SSIS Script Component</code>?</p>