This is a batch of SQL code I’ve been using:
BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM 'Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting'
( MAXERRORS =1000,
FIELDTERMINATOR = '^',
ROWTERMINATOR = '|n'
SELECT 'Error Caught'
Why would an error from this statement not be captured by the catch if the .CSV file is missing for the given directory?
July 15, 2008 6:52 PM
July 16, 2008 12:10 AM