Blog Post

Azure Database Support Blog
2 MIN READ

Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Jun 21, 2024
Today, I would like to share how to insert records from a CSV file stored in Azure Blob Storage into a temporary table in TempDB in Azure SQL Database using OPENROWSET and a format file.   First,...
Updated Jun 21, 2024
Version 1.0
azure sql database
bulk
OPENROWSET
tempdb
mbourgon_optum's avatar
mbourgon_optum
Copper Contributor
Jul 07, 2024

It feels like this has improved lately. 6 months ago it HAD to match standard CSV, and things like pipe-separated wouldn’t work - I’d opened tickets and everything. So kudos to the team for improving something that’s largely invisible but definitely needed.