question

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 asked MartinJaffer-MSFT commented

Openrow Issue

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'.

azure-data-factory
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @RohitKulkarni-3496 and welcome back to Microsoft Q&A.

If I am interpreting this correctly, then it ran into a newline when it was expecting a FIELDTERMINATOR.
This could mean one of the rows was too short, as in missing a column. This could also mean the data contained a newline which wasn't quoted or escaped.

0 Votes 0 ·

1 Answer

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 answered MartinJaffer-MSFT commented

I found there was issue of special character in the file

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

THank you for letting us know!

0 Votes 0 ·