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

%3CLINGO-SUB%20id%3D%22lingo-sub-1411184%22%20slang%3D%22en-US%22%3EImport%20data%20from%20Azure%20Blob%20storage%20using%20Bulk%20insert%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1411184%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3EI%20am%20facing%20one%20issue%20while%20using%20the%20BULK%20insert%20query%20to%20load%20a%20.csv%20file%20from%20Blob%20storage%20location%20to%20Azure%20SQL%20data%20base%20.%3C%2FP%3E%3CP%3EI%20am%20able%20to%20load%20data%20into%20sql%20data%20base%20tables%20but%20not%20not%20able%20to%20create%20ERRORFILE%20with%20error%20records%20in%20BLOB%20storage%20.%20i%20am%20getting%20below%20error%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMsg%204861%2C%20Level%2016%2C%20State%201%2C%20Line%204%3CBR%20%2F%3ECannot%20bulk%20load%20because%20the%20file%20could%20not%20be%20opened.%20Operating%20system%20error%20code%203(The%20system%20cannot%20find%20the%20path%20specified.).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20any%20one%20knows%20how%20to%20fix%20this%20error%20.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EDebi%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1411184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAZURE%20SQL%20data%20base%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

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 

0 Replies