Hello,
I am trying to perform a bulk insert in my SQL Server database, following the documentation here: https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15#f-importing-data-from-a-file-in-azure-blob-storage
I am testing it locally, using SSMS v18.4, SQL Server 2019 Developer Edition (Windows 10 Pro x64) and an Azure Storage Emulator (Azurite). When I try to run the bulk insert command, I get the error:
"Referenced external data source "MyAzureBlobStorage" not found."
Even though I successfully created that data source.
The blob storage emulator logs do not indicate any connection attempts when the command runs, although I can connect to emulator using a browser and it appears on the logs.
I wonder if this bug is related to the one reported here: https://feedback.azure.com/forums/217321-sql-database/suggestions/35725408-azure-sql-db-bulk-insert-to-support-blob-store-whe
The blob storage emulator is listening on: https://127.0.0.1:27161 (the default port is 10000, changing ports or using HTTP did not solve the problem)