Create report to check if file exists in a folder

• emmettjarlath

  SSC Veteran

  Points: 232

  More actions

  July 26, 2012 at 2:48 am

  #259803

  Hi,

  I am having an issue where I need to create a report where a user can check if a file exists on a directory.

  I have used xp_fileexists on my query analyzer but I cannot get anything to work on the Report Manager. The reason for this report is so it can be rolled out to many users.

  Ideally, I would like to create a report where the user could enter in the file name as a parameter, this would then check 3 folders returning with a message of the whereabouts of the file or a message saying it does not exist.

  Has anyone dealt with this issue before? I have trolled the internet and I keep coming short.

  Any suggestions would be greatly appreciated.

  Regards,

  emmettjarlath

• benjamin.reyes

  SSCertifiable

  Points: 5249

  More actions

  July 30, 2012 at 3:12 pm

  #1519440

  You should be able to pass a filename variable to a stored procedure that uses xp_cmdshell and a set of dos commands or powershell similar to this.

  http://cmille19.wordpress.com/2009/04/05/executing-powershell-in-sql-server/