Transform XML using XSLT in SSIS

For the client I needed to change the datastructure of the incoming XML file in the SSIS package. In my previous job I did a bunch of things with XSLT transformations so that seemed like an OK way to transform the XML. Turns out it's really easy in SSIS.

Check out this blog post: http://blogs.msdn.com/b/mattm/archive/2007/12/15/xml-source-making-things-easier-with-xslt.aspx

If you want to see how I solved it, check out my StackOverflow question: http://stackoverflow.com/questions/25661709/ssis-xml-datasource-unbounded-elements-are-null