Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

jovanpop-msft

Support DATA_SURCE in BULK INSERT statement

Submitted by Microsoft Employee on ‎04-21-2025 01:27 PM

The BULK INSERT Statement in SQL Server/Azure SQL has a DATA_SOURCE option that enables importing files from the paths relative to the DATA_SOURCE location, and also adding a custom authentication in data source.

Without the DATA_SOURCE option the BULK INSERT s limited to EntraID authentication only so SQL Server/Azure SQL BULK INSERT statements that use SAS, SPN, Managed Identity for authentication cannot be migrated to Fabric DW.

 

We need a DATA_SOURCE to migrate this kind of statements BULK INSERT (Transact-SQL) - SQL Server | Microsoft Learn

Status: New
See more ideas labeled with:
Comment