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?