Re: Importing XML Sample file and XML Schema

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

The targetnamespace indicates that the elements need to belong to the
namespace to be matched by the schema definitions.

Best regards
Michael

"Illustris" <Illustris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1EC9D995-DADE-4321-B9C4-AC8A55E07E51@xxxxxxxxxxxxxxxx
> Hello - found the issue - apparently, the:
>
> targetNamespace="http://tempuri.org/fra-bel-xml-MicrosoftBusinessSolutionsAxapta30_2.xsd";
>
> needs to be removed from the <xs:schema> tag.
>
> Now, can anyone tell me why? I'm not an XML expert but learning as much as
> I
> can...
>
> AB
>
> "Michael Rys [MSFT]" wrote:
>
>> You have a couple of options:
>>
>> Use the SQLXML 3.0 XML Bulkload component. You will need to add
>> annotations
>> to your schema (see the documentation).
>>
>> Use OpenXML. You pass the XML to a stored proc as a TEXT or NTEXT
>> parameter
>> (you need to make sure that the XML document is in an encoding compatible
>> with the SQL Server collation codepage).
>>
>> Write your own ASP/ASP.Net mid-tier code to perform the shredding.
>>
>> Best regards
>> Michael
>>
>> "Andi" <Andi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:FE4E6BEE-4BB2-452E-8A9B-BC9F0E20C3CE@xxxxxxxxxxxxxxxx
>> >I need to shred it. There are multiple tables involved.
>> >
>> > "Michael Rys [MSFT]" wrote:
>> >
>> >> Do you need to "shred" it into relational fields or keep the whole XML
>> >> document in a single field?
>> >>
>> >> Best regards
>> >> Michael
>> >>
>> >> "Andi" <Andi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:51CB2EE7-C1F2-4F3E-84FB-7BF425C154F2@xxxxxxxxxxxxxxxx
>> >> >I recently received a schema file from a vendor to import into my SQL
>> >> >Server.
>> >> > I am new to XML and have been reading all I can. I tried doing a
>> >> > Bulk
>> >> > Load
>> >> > in a DTS Package, but it does not read the schema as the correct
>> >> > file
>> >> > format
>> >> > (asking me ANSI, Unicode, etc). I have a sample data file to test
>> >> > with
>> >> > but
>> >> > it does not seem to be working. Can anyone give any insight on the
>> >> > easiest
>> >> > way to do this? I will be receiving a weekly feed from this vendor
>> >> > and
>> >> > will
>> >> > need to import on a schedule. Thanks.
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages