Any way of increasing the batch size above 1000 when exporting into a database?
1000 is the biggest batch size.
Do you mind sharing a bit more details about the issue? Maybe something else can help.
It was a 2 million row file being pushed into sql server. it worked in the end, but took a couple of hours
Two hours sounds like a lot. Although, it depends more on SQL Server’s performance of processing SQL INSERT queries, rather then on EM’s capability to generate them.
Two questions:
How many columns was in that table?
Is it possible to upload a text file to the server where the SQL Server is running? (in this case a bulk loading can be done).