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:12:45
|
| 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. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-10-31 : 09:42:23
|
| spirit1,Thanks for the reply. But I am only looking to import an XML file into SQL sever table using DTS. Isn't there anyway to do that?.Thanks in advance. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-31 : 10:02:25
|
as i asaid i have no idea about DTS.have you tried google?  Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-31 : 13:08:29
|
| after a second look i have to ask:Have you read this link i posted?http://www.perfectxml.com/articles/xml/importxmlsql.aspIt has 2 topics about importing with DTS:DTS ActiveX Script & SQLXML 3.0 Bulk Load DTS ActiveX Script & MSXML 4.0 DOM which explain nicly what to do.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
How to import an XML file in SQL Server using DTS?