Viewing 6 posts - 46 through 51 (of 51 total)
Can anyone suggest how can I first load 100,000 rows from sql tables, create xml file and dump the data into it and then load next 100,000 rows...
June 29, 2022 at 10:24 am
Unless you have a powerful server, I suspect "loads all the tables data into memory" may be a problem. You may be better off exporting the data to flat...
June 29, 2022 at 10:23 am
XML will definitely be slow.
It sounds like you're going from SQL Server to SQL Server. If that's the case, native format would be fastest.
Basically I have 23 XML...
June 29, 2022 at 10:16 am
That seems to be some custom SSIS component you're using, it's entirely possible it's not optimized properly. Have you tried just generating the XML in SQL Server with...
June 29, 2022 at 10:12 am
File size is not the issue.
I know there are many other methods but lets just say I have been given the task to produce it in XML.
Any possible way to...
June 28, 2022 at 8:26 am
Above XML data and SQL tables are just sample.
The XML files are multiple and way too big. Records are in millions.
Here is my query:
DECLARE @VAR1 INT =...
June 24, 2022 at 8:50 am
Viewing 6 posts - 46 through 51 (of 51 total)