You posted this in the Integration Services forum so why use bcp? Why not SSIS? If you do in fact need bcp you'll have to use a format file to specify the end of line char. Unfortunately when specifying on the command line using -r bcp prepends it with \r resulting in a runtime value of \r, which is not what you need.