Forum Discussion

msalter's avatar
msalter
New Contributor II
5 years ago

SQL Server Insert snap really slow

I’m writing ~ 200M records into a SQL DB but at the current rate (56,000 records over 2 hrs) I’ll be here a long time before it finishes. Wondering if I’m missing something in the setup or if there is something that needs to be tweaked elsewhere.

3 Replies

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago

    Single. But because directory browser will produce multiple documents, the file reader will be called as many times as there will be documents on input.

  • Supratim's avatar
    Supratim
    Contributor III
    4 years ago

    @amubeen hi… if you want to use Multi File Reader , you can config like below. But make sure all of your file should adhere same format (same set of header) else record can be mismatched. You can use filename convention in wildcard set.