I need to import an XML file(s) into SQL Server, and
subsequently export data in an xml format from SQL
Server. I tried using the DTS import/export text file
facility, but was very surprised that there weren't any
options for an xml formatted text file. Am I missing
something? I find it nearly impossible to believe that
SQL Server 2000 doesn't have a native means of importing
and exporting from/to an xml formatted file. Can anyone
suggest a means of accomplishing my objective?
I'm running SQL Server 2000 on Windows XP.