Can i load multiple txt files to table at one time

ELEVEN 80 Reputation points
2023-09-22T00:20:59.91+00:00

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
    2023-09-22T01:43:17.84+00:00

    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.

    Regards´╝î

    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
    2023-09-22T04:32:19.6333333+00:00

    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