Hi,

I need a code which should look for the particular folder (d:\test)
and find out the COUNT of the files (not the directory), if it has >= 3 files, the system should compare with my predefined date, something 2008-07-09 with the filedates and accordingly i should process...further.

So is there any way in TSQL where i can find out the count of the files and compare predefined date with the file date in the archive folder (predefined > filedate)



Thanks,
Chandra

__________________
Thanks,
Chandra

Is there a reason you are looking to do this in SQL? This is not such a SQL friendly task. Sure, it could probably be done, but it seems like the wrong tool for the job. You could create some .NET code that does this and make it a SQL CLR stored procedure if you really want to "run" it from SQL. Otherwise, use a better tool such as a command line app.

-Peter
compiledthoughts.com

So, if you're using xp_CmdShell already, by not use DIR with the /s option to find the diretory. Then use master.dbo.xp_Dirtree 'directoryname',1,1 to examine the file names.

--Jeff Moden