It took me some time to grasp the correct syntax for utilizing an XML format file in a BULK INSERT operation from Azure Blob Storage, but I’ve got it now:
BULK INSERT Invoices
FROM ‘Invoices_102023.csv’
WITH
(
DATA_SOURCE=’AzureBlobDS’,
FORMATFILE = ‘FormatFile.xml’,
FORMATFILE_DATA_SOURCE = ‘KAAAzureBlob’,
FIRSTROW=2
)