none
Copy Into Error File not working RRS feed

  • Question

  • Hi,

      We were looking to load data from Azure blob storage to SQL datawarehouse using COPY INTO which is currently in public preview. It's working fine, unless the errorfile option is used. Getting the below mentioned error when the errorfile location is blob storage. 

    Cannot bulk load because the file "https://xxxxx.blob.core.windows.net/xxx/Skipped_Records/_rejectedrows/20191231_132759/QID6820_1.Row.Txt" could not be opened. Operating system error code 5(Access is denied.).

    We did tried with Relative as well as absolute paths as error location with credentials as mentioned in the COPY INTO documentation. Also tried the access policies advised in https://social.msdn.microsoft.com/Forums/azure/en-US/9b583ef2-de9c-4ebc-b08e-d4cca333ded9/does-bulk-insert-from-azure-blob-storage-to-azure-sql-db-support-format-file-option?forum=ssdsgetstarted .

    Thanks in advance 

    Tuesday, December 31, 2019 2:05 PM

All replies

  • Me too looking for getting this resolved. As of my knowledge, the rejected details logging is working well with DATABASE SCOPED CREDENTIAL option. Can we use that with error file in COPY INTO?
    Tuesday, December 31, 2019 2:14 PM