The Painful Transition 1

[MarkZK]

Hi All,

I'm not completely sure that this is a SQL question in terms of actually executing the transition, or whether a SQL command could even achieve this, so my apologies before I even start.

Before I had access to a host with MS SQL databasing I made this application that dynamically and periodically creates an XML file to the server (now stores the data into a DB), what I'm wondering is if it's possible to extract the data from those old XML files (over 2,000 of them) and insert them into the database ?. My gut feeling tells me this is more of a job for ASP (some server-side), but I figure it was best to ask/learn to be sure.

Thanks.

 

[gmmastros]

I would suggest you do a little research on "SQL Server Integration Services".

This blog doesn't talk about XML data, but you might find it useful:

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[MarkZK]

Hi George,

Thanks for the link I'll have a look now.

 

[markros]

If you need some good links of SSIS, then check

http://social.msdn.microsoft.com/Fo...l/thread/e00f1cbb-794e-49fa-9977-f46f4ece798f

(answer by Kalman Toth)