I am trying to import csv file into sql server.
csv file data is
C,FD,20111231,0 8,000,C,ECB,FLL ,FLL,C1,,201111 1009592368,,,,,
C,IS,20111231,0 5,000,C,KWR,TPA ,TPA,F3,,201111 1009592368,,,,,
Bulk insert statement :
BULK INSERT dbo.TB_SAILING_ STAG
FROM 'C:\s1.csv'
WITH
(DATAFILETYPE = 'native',
Keepnulls, FIELDTERMINATOR =',',
...
User Profile
Collapse
Profile Sidebar
Collapse
pankajGoyal1958
Last Activity: Nov 10 '11, 07:04 PM
Joined: Nov 10 '11
Location:
-
pankajGoyal1958 started a topic Bulk load: An unexpected end of file was encountered in the data file.in SQL ServerBulk load: An unexpected end of file was encountered in the data file.
No activity results to display
Show More