question

manojjj44 avatar image
manojjj44 asked

SQL XML LOADING INTO A TABLE USING SSIS

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..
ssisdatabasexmlsql query
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton avatar image Shawn_Melton commented ·
Update your question with how you configured SSIS to perform the load.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.