SQL Server - eliminar archivos txt desde sql

declare	@cmd varchar(100),

@Path varchar(200) ,

@FileName varchar(255)

select	@Path = 'C:\pruebas\'  --- Mention the PAth

declare	@objFSO int

declare @i int

declare	@File varchar(1000)

declare @dt datetime

select @dt=getdate()-2 //solo como prueba

select @cmd = 'dir /B ' + @Path

create table #dir12(files varchar(1000))

insert #dir12 exec master..xp_cmdshell @cmd

select * from #dir12

while exists (select files from #dir12 where files is not null)

begin

select @filename = max(files) from #dir12

--Print @filename

select @File = @Path + @fileName

exec sp_OACreate 'Scripting.FileSystemObject', @objFSO out

exec sp_OAMethod @objFSO,'DeleteFile', null, @dt, @File

exec sp_OADestroy @objFSO

delete from #dir12 where files = @filename

end

drop table #dir12