bulk insert tabela
from 'M:\IO\tekst.csv'
with
( FIRSTROW = 2,
FIELDTERMINATOR=',',
ROWTERMINATOR='\n'
)
Dobijam ovu poruku:
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 289, column 13 (city).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1970, column 13 (city).
Nista neobicno nisam nasao u 289 redu.
Kada napravim posebnu tabelu sa samo datom kolonom (city) komanda je izvrsena bez greske.
Takodje sve kolone pre kolone city ulaze bez problema.