importing of XML files into SQL 2000

Hi,
How could i actually import an XML file directly into SQL Server 2000 from
the EM or Query Analyzer
i tried right-click on the tables --> import data but what should the data
source be ?
appreciate ur advise
tks & rdgs
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...er-xml/200602/1Look into SQLXML. So far it is the best way to insert large amounts of XML
data into a table.
"maxzsim via webservertalk.com" wrote:

> Hi,
> How could i actually import an XML file directly into SQL Server 2000 fro
m
> the EM or Query Analyzer
> i tried right-click on the tables --> import data but what should the dat
a
> source be ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...er-xml/200602/1
>|||Hi ,
I am not able to see SQLXML in the Data sources , how can i get that out ,
wat do i need to install ?
appreciate ur advice
tks & rdgs
Sal Young wrote:
>Look into SQLXML. So far it is the best way to insert large amounts of XML
>data into a table.
>
>[quoted text clipped - 7 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...er-xml/200602/1|||This is one of the examples included in the documentation of SQLXML add-on
component. You'll need your xml file and the schema (xsd) file.
Follow these steps:
1. Go to
http://www.microsoft.com/downloads/...&displaylang=en
and download the SQLXML add-on component. Install it on the machine where
you're going to run the DTS package.
2. Create a new DTS package and add an "ActiveX Script Task"
3. Insert the following code inside the Main() function:
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
with objBL
.ConnectionString = "provider=SQLOLEDB;data
source=localhost;database=dev;integrated
security=SSPI"
.ErrorLogFile = "C:\error.log"
.SchemaGen = true
.Execute "Salesorderdetail.xsd", "Salesorderdetail.xml"
end with
set objBL=Nothing
This solution works best when importing large amounts of data, otherwise, I
recommend using an "Execute SQL task" to call a stored procedure that uses
OPENXML.
"maxzsim via webservertalk.com" wrote:

> Hi ,
> I am not able to see SQLXML in the Data sources , how can i get that out
,
> wat do i need to install ?
> appreciate ur advice
> tks & rdgs
> Sal Young wrote:
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...er-xml/200602/1
>|||Hi,
search for OPENXML in the SQL Manual.
There you'll get an good example.
Achim
"maxzsim via webservertalk.com" <u14644@.uwe> schrieb im Newsbeitrag
news:5b4210d93706a@.uwe...
> Hi,
> How could i actually import an XML file directly into SQL Server 2000 from
> the EM or Query Analyzer
> i tried right-click on the tables --> import data but what should the data
> source be ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...er-xml/200602/1|||tks u ppl very much =)
Achim Stein [MCT] wrote:
>Hi,
>search for OPENXML in the SQL Manual.
>There you'll get an good example.
>Achim
>
>[quoted text clipped - 7 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...er-xml/200602/1

importing of XML files into SQL 2000

Hi,
How could i actually import an XML file directly into SQL Server 2000 from
the EM or Query Analyzer
i tried right-click on the tables --> import data but what should the data
source be ?
appreciate ur advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...r-xml/200602/1
Look into SQLXML. So far it is the best way to insert large amounts of XML
data into a table.
"maxzsim via droptable.com" wrote:

> Hi,
> How could i actually import an XML file directly into SQL Server 2000 from
> the EM or Query Analyzer
> i tried right-click on the tables --> import data but what should the data
> source be ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...r-xml/200602/1
>
|||Hi ,
I am not able to see SQLXML in the Data sources , how can i get that out ,
wat do i need to install ?
appreciate ur advice
tks & rdgs
Sal Young wrote:[vbcol=seagreen]
>Look into SQLXML. So far it is the best way to insert large amounts of XML
>data into a table.
>[quoted text clipped - 7 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...r-xml/200602/1
|||This is one of the examples included in the documentation of SQLXML add-on
component. You'll need your xml file and the schema (xsd) file.
Follow these steps:
1. Go to
http://www.microsoft.com/downloads/d...displaylang=en
and download the SQLXML add-on component. Install it on the machine where
you're going to run the DTS package.
2. Create a new DTS package and add an "ActiveX Script Task"
3. Insert the following code inside the Main() function:
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
with objBL
.ConnectionString = "provider=SQLOLEDB;data
source=localhost;database=dev;integrated security=SSPI"
.ErrorLogFile = "C:\error.log"
.SchemaGen = true
.Execute "Salesorderdetail.xsd", "Salesorderdetail.xml"
end with
set objBL=Nothing
This solution works best when importing large amounts of data, otherwise, I
recommend using an "Execute SQL task" to call a stored procedure that uses
OPENXML.
"maxzsim via droptable.com" wrote:

> Hi ,
> I am not able to see SQLXML in the Data sources , how can i get that out ,
> wat do i need to install ?
> appreciate ur advice
> tks & rdgs
> Sal Young wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...r-xml/200602/1
>
|||Hi,
search for OPENXML in the SQL Manual.
There you'll get an good example.
Achim
"maxzsim via droptable.com" <u14644@.uwe> schrieb im Newsbeitrag
news:5b4210d93706a@.uwe...
> Hi,
> How could i actually import an XML file directly into SQL Server 2000 from
> the EM or Query Analyzer
> i tried right-click on the tables --> import data but what should the data
> source be ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...r-xml/200602/1
|||tks u ppl very much =)
Achim Stein [MCT] wrote:[vbcol=seagreen]
>Hi,
>search for OPENXML in the SQL Manual.
>There you'll get an good example.
>Achim
>[quoted text clipped - 7 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...r-xml/200602/1
sql