How would I load mulitple XML files into a SQL Server Database.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hoardling1 - 15 Jun 2009 18:44 GMT

SQL Server 2008
XML files with and without Schemas

I am trying to load mulitple XML files from a file into my Database. Each
XML file will relate to a table.
How should I go about importing those XML files into the database. Please
provide an example due to my newness working with XML. Also if possible can
the XML file import not just be an INSERT, but an INSERT and UPDATE?

Thanks

Reply to this Message

Bob - 19 Jun 2009 10:41 GMT

You've got several options. Start in Books Online (BOL) with the following:

bcp straight to table
BULK INSERT straight to table
OPENROWSET straight to table or transform in-line with XML data-type and
methods ( eg nodes, value, query, exist )
SQLXML Bulk Load
SSIS

> SQL Server 2008
> XML files with and without Schemas
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Hoardling1 - 01 Jul 2009 16:53 GMT

Thank You, I will look at this information.

>You've got several options. Start in Books Online (BOL) with the following:
>
[quoted text clipped - 10 lines]
>>
>> Thanks

Reply to this Message