Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

I have followed all the steps you have mentioned in the bulk insert sample from Azure Blob Storage to Azure Sql.

Here's my table defintiion
CREATE TABLE Attendance(
[ATTENDANCE.SchoolID] varchar(100),
[Attendance.StudentID] varchar(100),
[Attendance.Attendance_CodeID] varchar(100),
[Attendance.Att_Date] date,
[Attendance.Period_ID] varchar(100),
[Attendance.Att_Mode_Code] varchar(100),
[Attendance.YearId] varchar(100)
)

BULK INSERT Attendance
FROM 'Attendance_export.csv'
WITH (
DATA_SOURCE = 'devStorage',
FORMAT='CSV',
FIRSTROW=2,
FIELDTERMINATOR=',',
ROWTERMINATOR = '0x0a',
TABLOCK);
When I do my insert this fails with the error
Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

I have tried every combination of parameters possible. What do I have to do to debug this issue?

Start with the supplied Attendance table definition and BULK INSERT statement, then compare them with the repository's bulk insert sample from Azure Blob Storage to Azure SQL. Reproduce the IID_IColumnsInfo error using the stated CSV and settings; done means documenting the confirmed cause and the configuration or sample change that resolves it.