BULK INSERT syntax error!?

[rao1soft]

Hi,

While using the following statement to do a load:

BULK INSERT mydb.dbo.mytable
from 'C:\data.txt'
with
(
fieldterminator = '|'
rowterminator = '\n'
)

I get an error "Line 6: Incorrect syntax near 'rowterminator'. Help appreciated.

--Rao.

 

[sunila7]

I think you have missed a comma after field terminator

Try this
BULK INSERT mydb.dbo.mytable
from 'C:\data.txt'
with
(
fieldterminator = '|',
rowterminator = '\n'
)


Sunil