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 |
|
wotrac
Yak Posting Veteran
98 Posts |
 Posted - 2003-03-09 : 16:16:56
|
| I don't know if this is the correct forum, but can anyone help me with importing XMl files in SQL 2000.The files will be attached to an e-mail and I wish to import or transfer them to a table in SQL 2000, automatically.Thanks any help would be appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-09 : 17:03:44
|
| SQL Team has an XML section:http://www.sqlteam.com/FilterTopics.asp?TopicID=128You'll probably want to look at the SQLXML package, it contains an XML bulk load utility that will probably do the trick.Getting the XML attachments is another matter. SQL Mail is poorly suited for this, you will need to look at an email application (maybe even need to write one) that can collect attachments and save them automatically to files, then run a job to bulk load them into SQL Server. If you are using or can use Outlook to access an Exchange mailbox, then the code to do it is relatively easy to write in Visual Basic. |
 |
|
|
|
|
|
XML Importation