I'm loading a | vertical bar delimited text file (400,000 records)into a SQL table with Bulk insert. I have the properties codepage and datafile setup to OEM and char.
I tried both the format file and setting the properties on bulk insert task to column delimiter = vertical bar and row delimiter = cr + lf. It loads just the numeric data. Worst thing is it loads the same record 400,000 times. I used tab delimiter, ACP, native - I mean tried different options but didn't make any difference.
I'm going crazy for last 2 weeks.
Any help is really appreciated.