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

Lucy Liu 0 Reputation points

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?


Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,011 Reputation points MVP

    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..