Importing XML data into Sql Server 2000

#1

Hi,

I need to import data from an XML file to SQL server 2000. Is there any way
of doing this through DTS without having to write code?

Thanks
--
pmud

#2

pmud wrote:

Quote:

Hi,

I need to import data from an XML file to SQL server 2000. Is there any way
of doing this through DTS without having to write code?

Thanks

There are some third parties that provide OLE-DB providers for XML, Data
Direct I think was one. There is nothing in the box. The next best thing
is the SQLXML Bulk Load component, but it is not DTS exactly.

--
Darren
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Importing XML data into Sql Server 2000

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Importing XML data into Sql Server 2000 - 01-30-2006 , 10:04 AM

Re: Importing XML data into Sql Server 2000 - 01-30-2006 , 02:12 PM