1. We can generate XML data from stored-procedure to a variable to pass it on to the XML using Microsoft in built method System.XML.XMLDocument.
2.    After passing XML data to the System.XML.XMLDocument method from variable it is not returning the XML file  we tried other alternatives like INSERTING into the table, various other Microsoft in built methods like System.XML.XmlSerialisation and passing the data to another variable but none of these attempts were successful. didnt work to generate it as single XML file.

Hi Marupaka,

Place the output to a file and then consume it in SSIS using the XML Source.

Another alternative would be to put it into a table (just more work setting the XML schema in DB).

Check the commercial COZYROC Template Task. You can generate text documents (including XML) with any complexity and layout.

Thanks,

When i insert the xml data into the table we are getting the following error.

The multi-part identifier "System.Data.DataSet"could not be bound.

Can you please advise.

Sounds like it is a coding error on your end because you treated it like a table that obviously does not exist.