You can use the new --skiprows option to specify that BCP must skip a specified number of rows before starting to copy from an input file. The valid range for --skiprows is between 0 and the actual number of rows in the input file. If you provide an invalid value, an error message is displayed.
--skiprows cannot co-exist with the -F option.
bcp --skiprows nSkipRows
where, nSkipRows is the numbers of rows you want to skip.
In this example, BCP ignores the first two rows of the input file titles.txt and starts to copy from the third row.
bcp pubs2..titles in titles.txt -U username -P password --skiprows 2
