Is there an easy way to reject rows using bulk insert in for it to continue inserting regardless of some bad data?
For instance (sample 1)
1,corrupttext,20 <--- needs to be rejected due to incorrect datatype column 2
1,3 <--- needs to be rejected due to improper EOF
I hava used MAXERRORS but it does not take care of these issues.
Any help will be appreciated.