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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

want to upload and download word document into SQL 2
Save text stream as binary in database 2
exporting blobs from access to xml 1
retrieving BLOB from Oracle 2
retrieving BLOB from Oracle 9
Store XML/XSD in SQL Server 2008 3
Oracle Lob (blob) Read / Write woes 3
Write dataset to XML and back again to dataset? 2

Back
Top