Can i load multiple txt files to table at one time

ELEVEN 80 Reputation points

Like titled, I try to use bulk insert, however, it seems does not work.

Suggest please.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,328 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 27,466 Reputation points

    Hi @ELEVEN,

    Not sure if you mean like this.

    First please make sure that the data in your .txt files has the same structure.

    You may check this thread step by step.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 36,191 Reputation points

    it seems does not work.

    "Doesn't work" means what in detail; we can't guess that?

    load multiple txt files to table at one time

    One SQL process can perform one operation like BULK INSERT at one time, it can load source data only one-by-one.

    0 comments No comments