SSIS:How retrieve and insert an XML Column
This can be done by converting the XML column when initially selecting it then casting it back to an XML data type for the insert.  This is outlined in further detail below.


In the first Execute SQL Task, select the XML column by casting it to an NVARCHAR data type.  Keep the Form_XML_Text variable as a string data type.  
In the Execute SQL Task within the Foreach Loop, set this variable to use the NVARCHAR data type on the Parameter Mapping pane.
Then in the SQL statement on the Execute SQL Task inside the loop cast it back to XML as done below.  This example assumes that the XML column is the second one in the destination table. 
I would also recommend always explicitly listing the columns when inserting into a table as follows.  This will make debugging easier and prevent errors that can occur if additional columns are added to the table in future.


Insert Example:

INSERT INTO TEST (Column1, XMLColumn)
VALUES (?, CAST(? AS XML))