I am trying to import a large txt file (9 million records) into sql server, some of the fields have large numbers in them, after import, I don't see the numbers, just horrible representations like: 4.01824e+009
I had made all the fields in the receiving table to be "nvarchar(255)" because I was getting import errors until I changed the expected fields to that (imported file fields may not be perfect)
I seem to be stuck with getting this file into sql server...is there a better / easier way to get such a file into the database? My command:
BULK INSERT claimfile FROM '\\localhost\ky\ky1.txt'
WITH (
FIELDTERMINATOR = '|',
ROWTERMINATOR = '')