Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

SSIS: Experience of using the XML Source Adapter

Roger Doherty, whom I have previously heard of through Conchango's involvement on the Ascend programme, has had some experience of using the XML Source Adapter and has written about it here. Worth reading if you intend using the XML Source Adapter at any stage.

Roger says he plans to write a series of blogs about a mini-BI implementation that he is doing so it could make for interesting reading. I for one will be keeping his blog on my aggregator.


For those that don't know, the XML Source Adapter enables you take an XML document and treat it as a source of rowset data. The data can then be used in an SSIS data-flow as if it had come from a flat file or a RDBMS.



Published Wednesday, March 30, 2005 10:01 PM by jamie.thomson



Mond said:

Realy good site!
September 16, 2005 9:47 AM


Hello Jamie,

I'm using XML Source to load data from an XML file to a SQL Server 2005 db.

I have to use 15 Outputs from the XML Source.

I look at the technique described by Matt Masson here http://blogs.msdn.com/mattm/archive/2007/12/11/using-xml-source.aspx but it doesn't fit all my needs as the Merge Join only takes two inputs.

I've heard the "cascade technique" but in a design point of view I found this "ugly".

Do you know a better way to handle multiple outputs from XML Source ?

Thanks a lot for your help and your blog which is a bible for me.



November 14, 2008 4:38 PM

James McMorrough said:

Hey Bertrand,

Why not just let the XML source create the tables you need, in a staging area, and then create a view over them using the generated _ID field relationships.

Or is that just 1 step too far?

August 13, 2009 6:03 PM
New Comments to this post are disabled

This Blog


Powered by Community Server (Personal Edition), by Telligent Systems