MS SQL Server DTS - Importing XML data into Sql Server 2000

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Importing XML data into Sql Server 2000

pmud

2006-01-30, 11:25 am

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

Darren Green

2006-01-30, 8:24 pm

pmud wrote:
> 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

Sponsored Links