Windows 10: Fix: BEGIN TRY does not work with BULK INSERT on SQL

I have created a stored procedure that does a BULK IMPORT. I wanted to add a bit of fault checking and added a BEGIN TRY and a BEGIN CATCH so that it sends an email with the error message if the T-SQL fails. The problem is that the BEGIN CATCH was being skipped and the procedure stops processing with the below error message.

Msg 4860, Level 16, State 1, Line 2
Cannot bulk load. The file "C:\temp\fileimport.txt" does not exist.

To fix the issue what I did is to add the BULK INSERT command in a variable and execute it. This way, the BEGIN CATCH is not ignored or skipped.

Fix below

BEGIN TRY
DECLARE @bulkimport varchar(1000)
SET @bulkimport = 'BULK INSERT mytable FROM ''C:\temp\fileimport.txt''
WITH (FIELDTERMINATOR = ''*'', ROWTERMINATOR = ''\n'')'
EXECUTE (@bulkimport)
END TRY

BEGIN CATCH
SELECT error_message()
END CATCH

(41)

read more...

 

Bulk Crap Uninstaller 4.3.4

• Added capability to open update link in web browser
• Fixed treemap not working correctly with only 1 item on the list
• Blacklisted "Installer" folder for drive scanning
• Relaxed overly strict check for questionable directory names
• Updated rate link to a new website

Klocman/Bulk-Crap-Uninstaller
https://github.com/Klocman/Bulk-Crap...ses/tag/v4.3.4

 

SQL Question

Its been a while since I wrote any advanced sql code, here is the statement if it was M$ SQL Server

MERGE services.corproster corp
USING (SELECT name FROM seat.corporation_member_tracking)
AS JoinResult
ON (corp.name = JoinResult.name)
WHEN MATCHED AND ISNULL(corp.name, '') <> ISNULL(JoinResult.name, '')
THEN UPDATE SET corp.name = JoinResult.name
WHEN NOT MATCHED THEN
INSERT name VALUES JoinResult.name
;

OR may be try this

BEGIN TRANSACTION
UPDATE corp
set corp.name = source.name
from services.corproster corp join seat.corporation_member_tracking source
ON corp.name = source.name
INSERT INTO services.corproster (name)
SELECT name FROM seat.corporation_member_tracking
where name not in (select name from services.corproster)
COMMIT TRANSACTION

I would only delete and insert if the table has less rows

 

Programs not working


In post 26 there were steps listed to fix the operating system corruption.
Are you able to follow them?
In post 29 was the suggested dism repair command.