I have a table with one only xml column. With SSMS, I am able to parse the XML and extract necessary data from it's tags. But when I configure it using SSIS, I am not able to load XML which has more data (say more than 1 MB data, that XML is not getting loaded) Also, when there are limited number of XML, loading is smooth(say 100), But when the number is huge(around 35000) then loading is not accomplished. How to remove these constraints and make XML with more memory(say around 10 Mb) and when more in number (say 35000) to load smoothly ?? Thanks for your help in advance..