Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2006-10-30 : 10:08:32
|
| Hi all,I want to import an XML file into a table.Under Enterprise Manager under the database (under console root on left) I right click on Tables, All Tasks, and Import Data.This will open the DTS Import/Export Wizard. Now under that what should be my Data Source???The SQLXMLOLED & SQLXMLOLED3.0 seems something else which I am not sure of. It doesnt even provide the aability to select the XML file that needs to be imported.So again to import an XML file into a table what should be my Data Source under DTS Import/Export Wizard?Thanks in advance. |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-10-31 : 09:43:22
|
| Still waiting for a feedback.Can anyone please help me on this.Thanks in advance. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-31 : 14:23:23
|
| We use the SQLXMLBulkLoad "COM" object for loading XML into staging tables (using a Schema to map the XML onto the tables & columns), and then from there into the final tables using standard SQL insert/update/delete/etc.Kristen |
|
|
|
|
|
|
How to Import an XML in to SQL sever ???