TRY在BULK INSERT中没有CATCH错误 [英] TRY doesn't CATCH error in BULK INSERT
本文介绍了TRY在BULK INSERT中没有CATCH错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
BEGIN TRY
BULK INSERT [dbo]。[tblABC]
FROM'C:\temp.txt'
WITH(DATAFILETYPE ='widechar',FIELDTERMINATOR =';',ROWTERMINATOR ='\\\
')
END TRY
BEGIN CATCH
select error_message()
END CATCH
我只是得到这个:
消息4860,级别16,状态1,行2
无法批量加载。文件C:\temp.txt不存在。
解决方案
这是一个有助于捕捉此错误的选项:
BEGIN TRY
DECLARE @cmd varchar(1000)
SET @cmd ='BULK INSERT [dbo ]。[tblABC]
FROM''C:\temp.txt''
WITH(DATAFILETYPE =''widechar'',FIELDTERMINATOR ='';'',ROWTERMINATOR =''\\\
'')'
EXECUTE(@cmd)
END TRY
BEGIN CATCH
选择error_message()
END CATCH
此后,我在CATCH中收到以下错误:
无法批量加载。文件C:\temp.txt不存在。
Why in the following code TRY didn't catch the error and how can I catch this error?
BEGIN TRY
BULK INSERT [dbo].[tblABC]
FROM 'C:\temp.txt'
WITH (DATAFILETYPE = 'widechar',FIELDTERMINATOR = ';',ROWTERMINATOR = '\n')
END TRY
BEGIN CATCH
select error_message()
END CATCH
I just get this:
Msg 4860, Level 16, State 1, Line 2
Cannot bulk load. The file "C:\temp.txt" does not exist.
解决方案
This is one option that helps to catch this error:
BEGIN TRY
DECLARE @cmd varchar(1000)
SET @cmd = 'BULK INSERT [dbo].[tblABC]
FROM ''C:\temp.txt''
WITH (DATAFILETYPE = ''widechar'',FIELDTERMINATOR = '';'',ROWTERMINATOR = ''\n'')'
EXECUTE (@cmd)
END TRY
BEGIN CATCH
select error_message()
END CATCH
After this I got the following error in CATCH:
Cannot bulk load. The file "C:\temp.txt" does not exist.
这篇关于TRY在BULK INSERT中没有CATCH错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文