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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!