I ran into a problem at work when trying to import an XML document to SQL 2005. The XML Source in SSIS was splitting my XML document into several outputs. This article helped me figure out how to join them back together again.
http://blogs.msdn.com/mattm/archive/2007/12/11/using-xml-source.aspx
Filed under: Technology | Tagged: MS SQL 2005, SQL, SQL 2005, SSIS, XML | Leave a Comment »