bcp with header/trailer records and skipping errors

Last Post 06 Mar 2008 09:59 AM by HarryNejad. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

06 Mar 2008 09:59 AM

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?


Acceptable Use Policy