Forum Discussion

Debi440's avatar
Debi440
Copper Contributor
May 22, 2020

Import data from Azure Blob storage using Bulk insert Azure SQL Database

Hello there,

I am facing one issue while using the BULK insert query to load a .csv file from Blob storage location to Azure SQL data base .

I am able to load data into sql data base tables but not not able to create ERRORFILE with error records in BLOB storage . i am getting below error .

 

Msg 4861, Level 16, State 1, Line 4
Cannot bulk load because the file could not be opened. Operating system error code 3(The system cannot find the path specified.).

 

Can any one knows how to fix this error .

Thanks

Debi 

No RepliesBe the first to reply

Resources