You can now use the new --skiprows parameter to skip the number of rows starting from the first row of an input file. This new feature provides BCP the ability to 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. Providing an invalid value will display an error message.
The new --skiprows parameter cannot
co-exist with the -F option.
The following BCP parameter is included to specify the number of rows you want to skip:
--skiprows nSkipRows
where, nSkipRows is the numbers of rows you want to skip.
In the following example, BCP will ignore the first two rows of the input file titles.txt and start to copy from the third row.
bcp pubs2..titles in titles.txt -U username -P password --skiprows 2
