My client will be uploading XML files to an FTP site and I need to import the data on a scheduled basis. Can anyone provide me with an overview of how this can be accomplished?
A simple way is to use write something to pick up the file into a string, pass into OpenXML. SQL also has some bulk load facilities for XML, we had a very recent article on it I think.