Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.