How to check .txt file existence with TSQL?

Question

I have a SP reading a .txt file from File System and using Bulk Insert. I just wanna make sure if file exists before executing bulk insert command. How do i do that?

Answer 1

try

xp_fileExist ' <file Name> '

The above returns a result set. If you want just a variable, use

declare @FileOK  INT

exec xp_fileExist 'c:\autoexec.bat' ,@FileOK OUTPUT

Print @FileOK