Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Support DATA_SURCE in BULK INSERT statement

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