I have a problem using BCP. The request and the exported file doesn’t have the same number of lines.
This is the command I use :
Exec master..xp_cmdshell 'bcp "SELECT [email],[title],[firstname],[lastname],[dateofbirth],[zip],''RS'' as raison_soc FROM […]" queryout "C:\Export\20120611003-0.csv" -c -T -CRAW '
The request executed out of BCP returns 6 695 695 lines.
BCP execution output is:
So the right number of lines is supposed to be returned.
The output file contains 6 911 814 lines, 216 119 added lines. None of them is doubled.
SQL server 2008
Bcp version 10.0.5500.0
Does anybody got any clue because I haven't...
Thank you in advance for any input.