By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,928 Members | 1,173 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,928 IT Pros & Developers. It's quick & easy.

Import BLOB from XML

P: n/a
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
Oct 31 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Oct 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.