I have a number of text files containing data records that I need to import into a database table.
1. The flat files have some header and trailer records that I need to have the process ignore, and bcp the rest of the records. There could be multiple header records and multiple trailer records
2. There could be records that cannot be transferred due to invalid values. These records must also be skipped.
How can I instruct the bcp to skip header/trailer and invalid records?