Share via

"Operating system error code 997(Overlapped I/O operation is in progress.)."

Lucy Liu 10 Reputation points
2023-11-02T16:09:13.0466667+00:00

I'm in SSMS using bulk insert to import data from a csv file into an Azure SQL DB. I am getting the following error:

"Cannot bulk load because the file could not be opened. Operating system error code 997(Overlapped I/O operation is in progress.)."

I've confirmed that the file is not locked and the proper permissions are set but still no luck. What does this mean and how do I resolve it?

Thanks!

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,611 Reputation points MVP
    2023-11-02T17:47:35.8666667+00:00

    What about creating a copy of the same file with a different name on the same Azure Storage container and try to upload the new copy of the file. Does that make the trick?

    Alternatively, you can also try to use bcp or BULK INSERT to achieve the same goal..

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.