How Do I Loop Through XML Datatype Within SSIS?

I have a SQL table that contains a column of type XML.  This column stores data in XML format that represent a row that needs to be uploaded to another server.  I need to have Integration Services read from this table and process each row.  Since row contains 1 XML column which will contain X amount of "rows".  Each row needs to be processed individually.

So... read table which has X amount of rows.  For each row read XML in column and loop through each Node which represents a given row.  Process/Insert the data within the XML (as parameters for another stored procedure).

I am hitting a wall here.  XML Source requires a variable or physcial file.  I am not sure how to do this with data from a SQL table of type XML.  Any ideas/help?
agorsky73Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
James MurrellConnect With a Mentor Product SpecialistCommented:
0
All Courses

From novice to tech pro — start learning today.