Troubleshooting BULK INSERT and OPENROWSET issues on Azure SQL Database

Published Jun 03 2019 06:20 AM 5,462 Views
Microsoft

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 some suggestions on steps you can take to troubleshoot and mitigate the issue.

 

  • If you are noticing that a syntax error is returned by BULK INSERT or BULK INSERT check that you are using supported syntax in this statement. As an example, if you are trying to load data via network share path note that this option is not supported in Managed Instance.
  • Make sure that you are using SAS key to access storage. Azure AD identities and managed identities are currently not supported.
  • Make sure that you are reading data from a public blob storage protected with SAS credential. Private IPs for blob storage and service endpoints are currently not supported.
  • If you are getting an error 5 (Access Denied), make sure that you have not denied access to your Azure Blob Storage account using the firewall:Storage firewall.png

 

  • Verify that you have created the EXTERNAL DATA SOURCE with type BLOB_STORAGE targeting the URL of the blob storage where you placed the files that should be restored to your database.
  • Make sure that you are targeting an existing file on Azure blob storage.
  • Script the CREDENTIAL to SQL Server 2017 and try to load the files. If you are troubleshooting the issue on Managed Instance make sure that SQL Server is in the subnet that is within the same VNet as the Managed Instance.
  • Check if your SAS credential placed in the SECRET option of the CREATE DATABASE SCOPED CREDENTIAL statement valid. The most common errors in SAS token parameters are:
    • ? is not removed from the beginning of the SAS token because the Azure portal generates SAS token with the leading ?. Remove this character if you see it.
    • se (expiry date) property is set to some value in the past (note that this is UTC time).
    • st (start date) property is not in the past (note that this is UTC time).
    • sp (permission) property should allow reading the file on the storage account.
    • sip (ip range) remove this parameter if it is present in SAS token.
4 Comments
Senior Member

I would like to add an update on the Bulk Insert Method. With recent enhancements related to Managed Identity now it is possible to do a Bulk Insert from firewall protected (VNET Service Endpoint) Azure Blob Storage to Azure SQL Database. I have documented the design in detail here - https://medium.com/@isinghrana/firewall-protected-azure-storage-and-azure-sql-database-load-data-usi...

 

 

Microsoft

@isr2020 Azure SQL do not support Managed Identity see - Microsoft Docs

 

This was not properly blocked in past and worked in some cases, but in general this scenario is not officially supported. Please update your article because people why try this will get the access error. 

Senior Member

Ok, thanks for letting me know that it was not properly blocked, I will add a big note at the top of the article. I am wondering if this explicit call out that Managed Identity will not work got added recently. This just means that there is no way to use Bulk Insert from a Blob which has Selected Networks setting rather than All Networks. I am on the Regulated Industry and none of my customers let that Storage Account Network setting to be All Networks. You have already mentioned this but SAS Signature will not work either so folks will need to find other methods to load.

Occasional Visitor

I resolved my issue from advice on this page:

 

CREATE DATABASE SCOPED CREDENTIAL (Transact-SQL) - SQL Server | Microsoft Docs

 

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.

 

%3CLINGO-SUB%20id%3D%22lingo-sub-664734%22%20slang%3D%22en-US%22%3ETroubleshooting%20BULK%20INSERT%20and%20OPENROWSET%20issues%20on%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664734%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20SQL%20Database%20(single%20database%20and%20Managed%20Instance)%20enables%20you%20to%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-SQL-Database%2FLoading-files-from-Azure-Blob-Storage-into-Azure-SQL-Database%2Fba-p%2F386133%22%20target%3D%22_self%22%3Eload%20files%20from%20Azure%20Blob%20Storage%3C%2FA%3E.%20If%20you%20experience%20issues%20while%20you%20are%20loading%20files%20from%20Azure%20blob%20storage%2C%20below%20are%20some%20suggestions%20on%20steps%20you%20can%20take%20to%20troubleshoot%20and%20mitigate%20the%20issue.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20margin-top%3A%200px%3B%20margin-bottom%3A%2012px%3B%20padding-left%3A%202.5em%3B%20list-style%3A%20outside%3B%20clear%3A%20left%3B%20color%3A%20%23333333%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2228%22%3EIf%20you%20are%20noticing%20that%20a%20syntax%20error%20is%20returned%20by%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3EBULK%20INSERT%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%20or%3C%2FSPAN%3E%20%3CCODE%20style%3D%22background-color%3A%20%23f9f2f4%3B%20border-bottom-left-radius%3A%204px%3B%20border-bottom-right-radius%3A%204px%3B%20border-top-left-radius%3A%204px%3B%20border-top-right-radius%3A%204px%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23c7254e%3B%20font-family%3A%20Menlo%2CMonaco%2CConsolas%2C%26amp%3Bquot%3B%20courier%20new%26amp%3Bquot%3B%2Cmonospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%202px%204px%3B%22%3EBULK%20INSERT%3C%2FCODE%3E%20check%20that%20you%20are%20using%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20title%3D%22supported%20syntax%20bulk%20insert%20openrowset%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-managed-instance-transact-sql-information%23bulk-insert--openrowset%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esupported%20syntax%20in%20this%20statement%3C%2FA%3E.%20As%20an%20example%2C%20if%20you%20are%20trying%20to%20load%20data%20via%20network%20share%20path%20note%20that%20this%20option%20is%20not%20supported%20in%20Managed%20Instance.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2228%22%3EMake%20sure%20that%20you%20are%20restoring%20a%20database%20from%20public%20blob%20storage%20protected%20with%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fstorage%2Fcommon%2Fstorage-dotnet-shared-access-signature-part-1%3Ftoc%3D%252fazure%252fstorage%252fblobs%252ftoc.json%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESAS%20credential%3C%2FA%3E.%20Private%20IPs%20for%20blob%20storage%20and%20service%20endpoints%20are%20currently%20not%20supported.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2228%22%3EIf%20you%20are%20getting%20an%20error%205%20(Access%20Denied)%2C%20make%20sure%20that%20you%20have%20not%20denied%20access%20to%20your%20Azure%20Blob%20Storage%20account%20using%20the%20firewall%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20display%3A%20inline-block%3B%20max-width%3A%20100%25%3B%20position%3A%20relative%3B%20width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-message-image-wrapper%20lia-message-image-actions-narrow%20lia-message-image-actions-below%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116415i12D12C318CD65A32%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Storage%20firewall.png%22%20title%3D%22Storage%20firewall.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20margin-top%3A%200px%3B%20margin-bottom%3A%2012px%3B%20padding-left%3A%202.5em%3B%20list-style%3A%20outside%3B%20clear%3A%20left%3B%20color%3A%20%23333333%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2229%22%3EVerify%20that%20you%20have%20created%20the%26nbsp%3B%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3EEXTERNAL%20DATA%20SOURCE%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%20with%20type%20%3CCODE%20style%3D%22background-color%3A%20%23f9f2f4%3B%20border-bottom-left-radius%3A%204px%3B%20border-bottom-right-radius%3A%204px%3B%20border-top-left-radius%3A%204px%3B%20border-top-right-radius%3A%204px%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23c7254e%3B%20font-family%3A%20Menlo%2CMonaco%2CConsolas%2C%26amp%3Bquot%3B%20courier%20new%26amp%3Bquot%3B%2Cmonospace%3B%20font-size%3A%2014.4px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%202px%204px%202px%204px%3B%22%3EBLOB_STORAGE%3C%2FCODE%3E%20targeting%20%3C%2FSPAN%3Ethe%20URL%20of%20the%20blob%20storage%20where%20you%20placed%20the%20files%20that%20should%20be%20restored%20to%20your%20database.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2229%22%3EMake%20sure%20that%20you%20are%20targeting%20an%20existing%20file%20on%20Azure%20blob%20storage.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2231%22%3EScript%20the%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3ECREDENTIAL%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Eto%20SQL%20Server%202017%20%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3Eand%20try%20to%20load%20the%20files.%3C%2FSPAN%3E%20If%20you%20are%20troubleshooting%20the%20issue%20on%20Managed%20Instance%20make%20sure%20that%20SQL%20Server%20is%20in%20the%20subnet%20that%20is%20within%20the%20same%20VNet%20as%20the%20Managed%20Instance.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2232%22%3ECheck%20if%20your%20SAS%20credential%20placed%20in%20the%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3ESECRET%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Eoption%20of%20the%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3ECREATE%20DATABASE%20SCOPED%20CREDENTIAL%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Estatement%20valid.%20The%20most%20common%20errors%20in%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fstorage%2Fcommon%2Fstorage-dotnet-shared-access-signature-part-1%23shared-access-signature-parameters%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESAS%20token%20parameters%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eare%3A%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20margin-top%3A%200px%3B%20margin-bottom%3A%200px%3B%20padding-left%3A%202.5em%3B%20list-style%3A%20outside%3B%20clear%3A%20left%3B%22%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2233%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3E%3F%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Eis%20not%20removed%20from%20the%20beginning%20of%20the%20SAS%20token%20because%20the%20Azure%20portal%20generates%20SAS%20token%20with%20the%20leading%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3E%3F%3C%2FCODE%3E.%20Remove%20this%20character%20if%20you%20see%20it.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2234%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Ese%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E(expiry%20date)%20property%20is%20set%20to%20some%20value%20in%20the%20past%20(note%20that%20this%20is%20UTC%20time).%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2235%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Est%3C%2FCODE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E(start%20date)%20property%20is%20not%20in%20the%20past%20(note%20that%20this%20is%20UTC%20time).%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2236%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Esp%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E(permission)%20property%20should%20allow%20reading%20the%20file%20on%20the%20storage%20account.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2236%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Esip%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E(ip%20range)%20remove%20this%20parameter%20if%20it%20is%20present%20in%20SAS%20token.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-664734%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20article%20provides%20guidance%20that%20can%20help%20you%20to%20troubleshoot%20potential%20%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EBULK%20INSERT%20and%20OPENROWSET%20issues%20in%20Azure%20SQL%20while%20loading%20the%20files%20from%20Azure%20Blob%20Storage%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EInteroperability%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMaintenance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EManaged%20Instance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426686%22%20slang%3D%22en-US%22%3ERe%3A%20Troubleshooting%20BULK%20INSERT%20and%20OPENROWSET%20issues%20on%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20add%20an%20update%20on%20the%20Bulk%20Insert%20Method.%20With%20recent%20enhancements%20related%20to%20Managed%20Identity%20now%20it%20is%20possible%20to%20do%20a%20Bulk%20Insert%20from%20firewall%20protected%20(VNET%20Service%20Endpoint)%20Azure%20Blob%20Storage%20to%20Azure%20SQL%20Database.%20I%20have%20documented%20the%20design%20in%20detail%20here%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmedium.com%2F%40isinghrana%2Ffirewall-protected-azure-storage-and-azure-sql-database-load-data-using-t-sql-bulk-insert-command-9895b258e480%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmedium.com%2F%40isinghrana%2Ffirewall-protected-azure-storage-and-azure-sql-database-load-data-using-t-sql-bulk-insert-command-9895b258e480%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Jan 29 2021 07:56 AM
Updated by: