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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
HarryNejad
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.

However:
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?

thanks,
You are not authorized to post a reply.

Acceptable Use Policy