I am trying to import data from a tab delimited text file using bulk import as follows:
BULK INSERT ABC.dbo.[data]
--FIELDTERMINATOR = '\t', -- default is \t (tab character)
ROWTERMINATOR = '\n',
The main problem I am having is that only half of the expected rows are being imported.
When I import the same file using DTS, all of the records are imported ok.
The file is being provided by the client from their FileMaker pro database. We switched to TAB delimited files because FileMaker seems to put out a non standard CSV !
Thanks in advance.