working with files with T-Sql

• lalibert16

  SSC Eights!

  Points: 928

  More actions

  March 11, 2005 at 11:25 am

  #65828

  Hi,

  I need to know if a file on the network exist with t-sql. Is that possible?

  Example:

  IF (file on the network exist) BEGIN ... END

  Thanks,

  Eric

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 11, 2005 at 12:14 pm

  #546703

  declare@Path varchar(128) ,

  @FileName varchar(128)

  select@Path = \\ServerName\ShareName\' ,

  @FileName = 'file.txt'

  declare @fe int

  declare@File varchar(1000)

  select @File = @Path + @FileName

  exec master..xp_fileexist @File, @fe out

  if @fe = 1

  print 'exists'

  else

  print 'not exists'

   

  
  * Noel

• lalibert16

  SSC Eights!

  Points: 928

  More actions

  March 11, 2005 at 3:03 pm

  #546743

  thanks! exactly what I needed!