RE: XML data source in SSIS

You are trying to use a column with the new-in-Yukon XML datatype as input to the XML Source, correct? It's somewhat counter-intuitive that our new-in-Yukon XML Source doesn't support this. Not sure what the best workaround is in your scenario -- your best bet is to ping the SSIS forum at http://forums.microsoft.com/msdn/showforum.aspx?forumid=80&siteid=1



I am trying to convert an XML column into relational form. I need the XML data source to get XML documents from a table column of type XML. Presently the XML data flow source only allows file and variable sources. I would appreciate any suggestions to solve this problem.
.

Loading