I have a folder with about 10.000 xml files that need to be transferred to a
SQL table.
the structure of the xml file is something like this:
<?xml version="1.0" encoding="UTF-8"?>

I'm doing an SQLXMLBulkLoad, and keep getting messages like this:
   Could not bulk insert. File 'c:\Temp\BL_200562842335587_6.txt' does not
exist.
Now, these BL*.txt files are nothing to do with me (directly) -- I'm dealing

I'm in the process of trying to get to grips with SQLXML and I am trying the
examples in the MSDN article "Exchanging XML with SQL Server 2000 and
Reporting Services through the Web and Web Services".
In the section: "Templates: XSL, XPATH, and XDR":-

Here is my context ( SQL server version : 9.00.1116.00 ) ( CPT April )
1- I've created a "Business" Database
USE [Business]
GO

I have been able to write an activeX control for a DTS in SQL server 2000 to
open and parse a .xml files from a folder.  I can get it to read a specific
file, but can I also get it to read all files from a folder?  Also I need
help reading and storing a specific attribute in the ...

In My initial experience using SQLXML 3.0 I have been pulling XML from
SQL tables using Schema Definitions and Template files.
Now that I have my URL queries working and generating XML into IE and
the browser in the Visual Studio IDE I need to save the output to an

i am using sql server 2000 SP 4 and i had also installed SQLXML 3.0 SP 2
i had some XSD in my virtual directory when i query my xsd then for simle xsd
which are based on a single table it works fine as show below
<?xml version="1.0" encoding="utf-8" ?>

Hi fellows,
I am a newbi, so new to these discussion groups. I am facing following poblem:
Passing a XML to SP, and SP also is returning XML. When i commentout
sp_xml_preparedocument block, ASP is taking returning XML, but as i uncomment

I need to import large XML files into an SQL table.
My XML experience is minimal....
My current DTS script can import xml files which are more structured (using
NODES) and works fine.  How ever i need to modify it to look at Attributes

I have to create a B2B application in c#.Net and use SQLXML and use
Annotated schemas to get output as XML.
I have no background in any of these.  First of all i have to set up
the environment. So I installed win XP pro ,SQL Server 2000 and tried

I can't seem to nail down the correct way to use OpenXml with input Xml that
conatains a root namespace.
'=================================
   PROC

I have a script that can read specific files that are in an xml format, but i
need to modifiy it to read all files from a folder.  In this case, I do not
know the file names but I do know that I need to read all of them.  Does
anyone have a VB activeX script for this for MS SQL ...

Please help shed some light on this...
I have been converting dates in string form to SQL Server datetimes happily
for many months. I use the xml form of the date like this: '2005-06-22'
which SQL server casts correctly to a date time.

How do I set up a routine to automatically import data from xml files into a
database table in sql server 7? All the solutions I have looked at seem to be
using Sql server 2000 so I'm not quite sure where to start - please help...

Using a nested FOR XML EXPLICIT statement within an FOR XML PATH query is it
possible to create a node creating cdata?
For example, the statement;
select