MSSQL2k retrive data from xml

Hello
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS'
AJAHello AJA,

> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS'
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong :(
Best Regards
AJA|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
--
Monica Frintu
"AJA" wrote:

> Hello
> I have mssql 2k there database and few XML files. I try get data from XM
L
> files and insert into database. How to do that using DTS'
>
> AJA
>

MSSQL2k retrive data from xml

Hello
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS?
AJA
Hello AJA,

> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS?
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong
Best Regards
AJA
|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA
|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
Monica Frintu
"AJA" wrote:

> Hello
> I have mssql 2k there database and few XML files. I try get data from XML
> files and insert into database. How to do that using DTS?
>
> AJA
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech Znaniecki
Is SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegro ups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech ZnanieckiIs SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegroups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>