When running the code below management studio shows an error in which it is set down.
I need to insert simple text data into the tables through BULK INSERT. The code for insertion is as follows:
BULK INSERT Pais FROM 'C:\[bulkdata]\shared\01-Pais.txt'
WITH(MAXERRORS = 0, CODEPAGE = 'ACP', FIELDTERMINATOR = 'ø', ROWTERMINATOR = '\n', KEEPNULLS,
ERRORFILE = 'C:\[bulkdata]\shared\teste.txt')
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Row 1 File Offset 0 ErrorFile Offset 0 - HRESULT 0x80004005
It seems to be a
character issue, you can try with another one like
You just need to do a little tweak:
FIELDTERMINATOR = '§'