Blog Post

Azure SQL Blog
2 MIN READ

Troubleshooting BULK INSERT and OPENROWSET issues on Azure SQL Database

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Jun 03, 2019
Azure SQL Database (single database and Managed Instance) enables you to load files from Azure Blob Storage. If you experience issues while you are loading files from Azure blob storage, below are so...
Updated Aug 03, 2022
Version 9.0
azure sql
azure sql managed instance
StevenJacobs1735's avatar
StevenJacobs1735
Copper Contributor
Jul 02, 2021

I resolved my issue from advice on this page:

 

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql?view=sql-server-ver15

 

The SAS key value might begin with a '?' (question mark). When you use the SAS key, you must remove the leading '?'. Otherwise your efforts might be blocked.