Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-17 : 13:00:40
|
| Thangamani writes "Hello Team,I am Thangamani, new to SQL Server Stored Procedure Programming.I am writing a SP which executes a BULK INSERT command to load data from a text file (contains tab delimited data). Based on status, like success or Failure, a record needs to be inserted in another table called Status table.Upon successful execution is doing fine. But, if BULK Insert fails due to some file corruption problem, the SP execution fails, the status insertion fails. The total SP gets terminated there itself. Please help me to overcome this problem.Thanks in advance,Thangamani" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Error trapping in BULK INSERT 