XML reading - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

XML reading

Author

Topic

gurusamy.senthil
Yak Posting Veteran

65 Posts

Posted - 2007-02-14 : 01:31:12

Hello Everyone,

My client currently has a VB screen. The working functionality of the screen is to read the XML file and write the data into sql table and this process is automated to work every one hour. After reading from the XML file, the process will transfer the XML file to another specific folder which is hardcoded in a program. To make this happen everytime the client needs to open the screen and have to click the Begin Process button. This process needs the screen to be open always to get running.

So the client want the above process is to done using Sql service which has to read the XML file from the specific folder and write data into sql table and this process is automated to run for every one hour. After reading XML file the sql service have to transfer the XML file to another specific folder.

Please advice.

Thanks,
Senthil .G

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-14 : 14:49:39

You can find out about lots of different ways to do it here
http://www.yukonxml.com/articles/sql2000xml/