you could load directly from MSSQL using a
SQL Input Source. You can parallelize it by sending multiple SQL statements with different filters and configure it for multiple tasks.
If you want to use the files, makes sure to export to more than one file to increase parallelism of the input step.
Can you share your ingestion spec?