Re: How to decode binary base 64 data using OPENXML

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The first article you reference there mentions using a schema to specify the
data type as bin.base64 and then use an updategram or bulk loading. So it
seems that there is no way to use a schema with OPENXML? The WITH clause is
a kind of schema, I suppose, but perhaps it does not allow for information
such as the bin.base64 encoding? I'd like to verify that I am unable to do
what I want to do with OPENXML before I start exploring the updategram and
bulk loading topics, about which I know very little.

"Michael Cheng [MSFT]" <v-mingqc@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:YiIAicoaFHA.3336@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Jason,
>
> Welcome to use MSDN Managed Newsgroup!
>
> From your descriptions, I understood you would like to know how to decode
> BINARY BASE64 using OPENXML. If I have misunderstood your concern, please
> feel free to point it out.
>
> Based on my scope, I am afraid we are not able to do this directly with
> OPENXML and you may refer the articles below on about
>
> How To: Inserting Binary Data using XML
> http://sqlxml.org/faqs.aspx?faq=51
>
> How To: Retrieving binary data using XML
> http://sqlxml.org/faqs.aspx?faq=52
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>


.

Relevant Pages

  • Re: problem - get the @@identity in MAP
    ... this is my updategram schema structure ... This my input schema structure(i.e Source Schema for Map) ... The adapter failed to transmit message going to send port ...
    (microsoft.public.biztalk.general)
  • Re: using updategram to update multiple records in SQL (BizTalk 2004)
    ... Create a schema that includes the updategram elements/attributes that you ... Update the sql adapter generated schema to include this attibute in the ... > | the before/after nodes but, even though I generated the required XML ...
    (microsoft.public.biztalk.general)
  • Re: Bulk importing XML to SQL 2000
    ... The problem is in the schema. ... XML file to the text field in a table but cannot pass the text data to the ... This format can be used by OPENXML but cannot use the Bulk Importing. ...
    (microsoft.public.sqlserver.xml)
  • Re: XML files to SQL server
    ... > Thank you Matt, I tried the AIC sample for the Products table and it looks ... However I have problems arriving at the schema when I try to use ... > The updategram expects the XML to be generated like below. ... > suitable for an XML updategram. ...
    (microsoft.public.biztalk.general)
  • Re: using updategram to update multiple records in SQL (BizTalk 20
    ... managed to get this working using Matts instructions below. ... Supplies.xsd = this is the source schema ... UpdateSupplies.xsd = this is the updategram. ... >> namespace as the namespace for your schema. ...
    (microsoft.public.biztalk.general)