The tutorials for SSIS include an example of processing a text file. The process for handling an XML file is probably not THAT much different.
Originally Posted by fmardani
There are also books on SSIS from WROX and many other publishers that you can read.
You probably won't get a whole lot of help from this board on SSIS. Some members are philosophically opposed to the idea of using it while others (myself included) are baffled by the newness and complexity of SSIS (and desperately wish for a return to the relative simplicity of DTS).
Have you hugged your backup today?