Hi,
I am trying to import an XML file into SQL server 2000. Can someone tell me how to do this. Eventually i want to automate the import in DTS.
Thank you
My file format is:
<?xml version="1.0" encoding="UTF-8"?>
<!-- created by FLARE using ascxml.q from ascii file -->
<Notices>
<Notice>
<prref>Q01PCI359-/1</prref>
<type>S08</type>
</Notice>
<Notice>
<prref>R18DFA39BB/1</prref>
<type>S08</type>
</Notice>
<Notice>
<prref>P05GCO5PAR/1</prref>
<type>T13</type>
</Notice>
<Notice>
<prref>R02GCE27ST/1</prref>
<type>T13</type>
</Notice>
</Notices>
I am trying to import an XML file into SQL server 2000. Can someone tell me how to do this. Eventually i want to automate the import in DTS.
Thank you
My file format is:
<?xml version="1.0" encoding="UTF-8"?>
<!-- created by FLARE using ascxml.q from ascii file -->
<Notices>
<Notice>
<prref>Q01PCI359-/1</prref>
<type>S08</type>
</Notice>
<Notice>
<prref>R18DFA39BB/1</prref>
<type>S08</type>
</Notice>
<Notice>
<prref>P05GCO5PAR/1</prref>
<type>T13</type>
</Notice>
<Notice>
<prref>R02GCE27ST/1</prref>
<type>T13</type>
</Notice>
</Notices>