Import XML Image Blob Into SQL 2000
- From: "Scott O'Sullivan" <drear80@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 12 Jul 2006 11:02:23 +1000
Hi,
I want to import an image blob from an XML file into MS SQL 2000. I'm new to
importing XML, so any help on this would be great.
I've followed the procedure from this KB article...
http://support.microsoft.com/default.aspx/kb/316005/en-us
But when I try to execute the VB script I get the error message...
"Error: Invalid character value for cast specification
Code: 80004005"
I think the problem is with the dt:type for the image blob in the mapping
schema file. I've tried using LONGVARBINARY but with no success. If I remove
the image column from the schema, the other columns import fine.
If anyone could shed some light on this for me, it'd be greatly appreciated.
Thx,
Scott.
.
- Follow-Ups:
- Re: Import XML Image Blob Into SQL 2000
- From: Scott O'Sullivan
- Re: Import XML Image Blob Into SQL 2000
- Prev by Date: Re: xml datatype, UTF and BMP
- Next by Date: Re: Import XML Image Blob Into SQL 2000
- Previous by thread: Re: xml datatype, UTF and BMP
- Next by thread: Re: Import XML Image Blob Into SQL 2000
- Index(es):
Relevant Pages
|
Loading
