Search code examples
sqlstored-proceduresfile-exists

Files in SQL stored procedure


I'm currently tasked with reading some data that stored in a flat file into my database and run reports against it. The one problem I'm running into is checking to see if a file actually exists. Is there a simple function to check if the file exists?

Thanks!


Solution

  • Just googling I found this at SQL DBA and this at MS SQL tips.