XML Source – Making things easier with XSLT

As I wrote in my previous post, complex XML documents will produce multiple outputs when you’re using the XML Source adapter. Most of the time it will be easier to pre-process your source file with XSLT to de-normalize it a bit. Reducing the number of outputs greatly simplifies your data flow. Let’s take the same…


Using XML Source

Providing a generic way to extract data from XML documents of any format is pretty complicated. The SSIS XML Source Adapter tries to do just that, to various degrees of success. XML Source is easiest to use when your input has a simple element/sub-element structure: <rootgoo> <goo> <subgoo>value</subgoo> <moregoo>1</moregoo> </goo> <goo> <subgoo>value</subgoo> <moregoo>2</moregoo> </goo> </rootgoo>…