Batch Size - Export to database

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).