SQL Server DBAs will often come across a scenario where they need to load data from an XML document into SQL Server 2005 or 2008. As XML is being used widely by many organizations to communicate and share data, it is becoming a common task for DBAs to load XML data into SQL Server. This article provides a step by step guide on how to create an configure an SSIS package which can be used to import data from XML file to SQL Server 2008.
The article continues at http://sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx