title: Getting a System.Byte[] from a SSIS package ADO.NET datasource
body: <p>I'm using a SSIS package to retrieve Data from active directory and to make a few conversions and write it into a SQL Server destination table (via update ole db command).</p>
  
  <p>Now I've run into the problem that one of the fields retrieved is of type System.Byte[] and it is the TYPE that is written into the field of the sql server database (thus the field UserSID gets the value "System.Byte[]" instead of the user SID itself.  the userSID is a unicode varcahr with a max. length of 255).</p>
  
  <p>ole db source sql command:</p>
  
  <pre><code>SELECT extensionAttribute2, mail, objectSID FROM 'LDAP://XXXXXXX' WHERE objectClass='User'
  </code></pre>
  
  <p>So my question here is: how can I get the value and not the type back from the source object?</p>