String To Binary
or
Sttring To Hex

Dim Mac(5) As Byte
Dim i As Integer


For i = 0 To Row.MacAddress.Length - 1 Step 2
    Mac(CType(i / 2, Int32)) = Convert.ToByte(Row.MacAddress.Substring(i, 2), 16)
Next
Row.MacAddrBin = Mac

Retrieved from http://w.databaser.net/moniwiki/wiki.php/SSIS-StringToBinary
last modified 2018-04-13 23:12:53