Hello Team,
The file already present in the location mentioned below .But when i try run the openrowset statement i am getting error :
SELECT * FROM OPENROWSET(BULK 'https://storagename.blob.core.windows.net/staging-zone/FolderName/Tables/Vendor/Vendor_00000.csv'
, FORMAT = 'csv' , Parser_Version= '2.0' , FIELDTERMINATOR = '|' , FIELDQUOTE='"' , ESCAPECHAR = '\')
WITH
( [timestamp] nvarchar(100)) as r
Error handling external file: 'Unexpected token 'M\' at [byte: 901533]. Expecting token '|'. '. File/External table name:
'https://storagename.blob.core.windows.net/staging-zone/FolderName/Tables/Vendor/Vendor_00000.csv'.