• XML structure that goes more than 2 levels deep performs horribly with SSIS during the development cycle. Drop-downs where you are picking a node could take minutes, and even hours to load if the XML has a complex structure.

    The only reasonable performance comes with using openrowset, XPATH, etc.

    Using SSIS best practices isn't always the best performing way of accomplishing a task.