Share via

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,567 questions
Accepted answer
  1. ZoeHui-MSFT 36,191 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,311 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.