Falla en la ejecución bulkcopy

Question

Buenas tardes
Estoy presentando una falla con la ejecución del bulkcopy sobre la base de datos en Azure sql Server con el usuario administrador y no me permite realizar esta acción. El error que se presenta es el siguiente:

Mens. 4861, Nivel 16, Estado 1, Línea 16
Cannot bulk load because the file "xxx.txt" could not be opened. Operating system error code 5(Access is denied.).

Se revisó los permisos dentro del storage account donde se esta realizando la consulta del archivo y se cuentan con todos los permisos de lectura/escritura correspondiente pero aun no permite la ejecución.

Agradezco de su colaboración para ver la solución de este error

Quedo atento, mil gracias

====================================================================

TRANSLATION:

Good afternoon
I am presenting a failure with the execution of bulkcopy on the database in Azure sql Server with the administrator user and does not allow me to perform this action. The error is as follows:

Mens. 4861, Nivel 16, Estado 1, Línea 16
Cannot bulk load because the file "xxx.txt" could not be opened. Operating system error code 5(Access is denied.).

The permissions inside the storage account where the file is being consulted were checked and all the corresponding read/write permissions are in place, but it still does not allow the execution.

I appreciate your cooperation to see the solution to this error.

I remain attentive, thank you very much

Answer 1

Please make sure you created the external data source:

CREATE EXTERNAL DATA SOURCE MyAzureBlobStorage  
 WITH ( TYPE = BLOB_STORAGE,  
        LOCATION = 'https://myazureblobstorage.blob.core.windows.net',  
        CREDENTIAL= MyAzureBlobStorageCredential);  

This documentation and its examples may really help you.