Cannot bulk load because the file "1427664189517725696/export-705810599278007420.tmp" could not be opened. Operating system error code 5(Access is denied.).

Question

Cannot bulk load because the file "1427664189517725696/export-705810599278007420.tmp" could not be opened. Operating system error code 5(Access is denied.).

Ayush Shrivastava 120

This error occurs when I try to run bulk insert query. This was working a few days back but its not working now.

Weird thing is, the same query works in a fella developers MacBook and not mine.

Running this using JDBC.

Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-16T14:14:56.71+00:00

Hi @Ayush Shrivastava,

Just checking in to see if the below answer provided by @Sina Salam helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-16T14:14:56.71+00:00

Hi @Ayush Shrivastava,

Just checking in to see if the below answer provided by @Sina Salam helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hello Ayush Shrivastava,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you have an Operating system error code 5(Access is denied.) while running bulk insert query using JDBC.

This error could happen to any executable file not because it's Azure SQL query or Azure Blob storage, it is a permission issue. You can use your SQL Server service account that have rwx to run the query, and make sure SQL Server has access to the entire folder as well as checking that firewall setting is not blocking access to the file.

The links below will guide you for similar question and more details:

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator

2024-09-17T17:13:47.9166667+00:00

Hi @Ayush Shrivastava,

Just checking in to see if the above answer provided by @Sina Salam helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Cannot bulk load because the file "1427664189517725696/export-705810599278007420.tmp" could not be opened. Operating system error code 5(Access is denied.).

1 answer

Your answer