title: SQL Server 2005 bulk insert binary types
body: <p>I have a table in the following format:  </p>
  
  <pre>
  smallint, binary(10), smallint, smallint, varbinary(max)
  </pre>
  
  <p>I also have a csv file generated from the data in the table by one of our processes where binary data is exported as hexadecimal data.<br>
  I tried generating INSERT INTO statements which worked but was very slow..<br>
  I tired BULK INSERT but it is failing and i suspect it is because of the binary data.</p>
  
  <p>Anyone know how can i use BULK INSERT (or something like that ) to insert big amount of data that includes binary data?  </p>
  
  <p>An example of the data:</p>
  
  <pre>1,0x00000000000000000BB8,0,142,0x434F4E534E554D424552202020202020040006000600202000000000202000000000000000008000422020202020202020202020202020202020000000000000000000000000000000000000202000000020000000000000000000000000000000000000000000000000000000000200020000000000000004000000E09304006B8016000600FFFFFFFF0B00010007004633303030002E81FFFF1C00FFFFFFFF04001E00</pre>
  
  <p>Thanks.</p>