Import BLOB from XML

  • Thread starter Thread starter Daren Hawes
  • Start date Start date
D

Daren Hawes

Hi,

I have been given a XML file containing Image BLOB data. They probably did
a dataset.writeXml() to get the XML fule loaded.

How can I import this into my MS SQL Server?

I have tried simple inserts, Stored Procedures and Command Builder ideas
however it all boils down to converting a string to Image Binary.

Can anyone please shed some light or point me in the correct direction?

Can we even export Blob into XML? Maybe thats the problem?

Thx Daren
 
Chunk in as a byte array. Most likely the blob is base 64 in the XML file,
so you will have to convert it back to a byte array, but then you should be
able to attach to an input parameter on a stored procedure or parameterized
query.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************
 
Back
Top