Viewing 5 posts - 1 through 6 (of 6 total)
Ok, well, I have to admit defeat here! When I did look at the file on the sql 2012 side, you are absolutely correct. It now contains the 0d0a for...
June 29, 2018 at 12:59 pm
That's what I am trying to say. The same file, verified both on each system, the row terminator in each file is 0x0a using hex editor. Give me a few...
June 29, 2018 at 12:50 pm
The file is exactly the same on both systems. It's downloaded from the vendor as a csv file, and we test it in dev & test environment, and when successful...
June 29, 2018 at 12:40 pm
Yes, I can get the file to load in both systems by specifying 0x0a as the row terminator, the issue is that in Sql 2012 it includes the CR and...
June 29, 2018 at 12:35 pm
Yes, that I did. The Row Terminator is a hex 0A.
BTW, I am trying to load the same file in both environments.
Thanks!
Pat
June 29, 2018 at 12:23 pm
Viewing 5 posts - 1 through 6 (of 6 total)