Loading an XML file’s dataset into an existing SQL Server 2005 table
I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 20, 2009 2:52 PM
UPDATED:
April 20, 2009 3:40 PM
RELATED QUESTIONS
- Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format
- export xml file of new stored data into a folder through trigger in sql server!
- SharePoint_SQLSERVER tables using SSIS
- Inserting DB2 records on iSeries to SQL Server 2005 Table
- Recovering lost data from SQL Server 2005
Answer Wiki:
Hi you might consider using <a href="http://msdn.microsoft.com/en-us/library/aa225754(SQL.80).aspx">XMLBulkload</a> .
I successfully used it in the past and it's a really nice tool.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
