How can I catch error from Bulk Insert, if file for import doesn't have good
data types? I want to send email to me if Bulk Insert fails, but it's not
Error message is below.
I'm using SS2000 Enterprise edition SP1 on Win2000 Advanced Server SP2.
Thanks in advance
Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1.
Make sure the field terminator and row terminator are specified correctly.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any
information about the error.
The statement has been terminated.