SSIS 2005 Multiple XML documents

[caubbinna]

Folks, Is there any way I could return two separate XML documents in one 'Execute SQL Task'?1) Create a stored procedure that returns two separate XML documents2) Configure the 'Execute SQL Task' so it has: - ADO.NET connection manager, - it calls the stored procedure, - it has resultSet set to 'XML', - and on the 'Result Set' lever the output is mapped to two separate string variables: e.g.:ResultName: 0 - VariableName: firstVar, ResultName: 1 - VariableName: secondVar; It all work fine if I have the 'Result Set' with only one result variable - it nicely returns the first xml from the called stored procedure and maps it to the variable. When I add the second variable i get the error:[Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_XML". Is this possible to achieve this one task?Thank you in advance.