question

Carlosvega-7631 avatar image
0 Votes"
Carlosvega-7631 asked AlbertoMorillo edited

Falla en la ejecución bulkcopy

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

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.