Import BLOB from XML

[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

[Cowboy \(Gregory A. Beamer\)]

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!
*************************************************
"Daren Hawes" <ne********@webdesignmagic.com.auwrote in message
news:eF**************@TK2MSFTNGP05.phx.gbl...

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