Looks like its an issue with the data file.

I tried all the options but this works with -n option.

There are some extra characters which I after truncating, the bcp works...

Hi,

I did check that. Its the same. The dat file has a new line character as rowdelimiter. The bcp is unable to read that. I have 25 columns in the...