dealing with large txt files and db

[rutledj]

Whats the best way to deal with tab delimited txt files where several fields in each record need to be compared to corresponding fields on a sql server db table and that table updated as needed.

How do you reduce the number of db hits for making comparisons to each record?