Import BLOB from XML

31 Oct 2006 9:02 AM

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

31 Oct 2006 2:13 PM

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!
*************************************************

Show quoteHide quote

"Daren Hawes" <newsgro***@webdesignmagic.com.au> wrote in message
news:eFizUvM$GHA.4468@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
>