Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 File exists in a folder

Author  Topic 

thanksfor help
Posting Yak Master

106 Posts

Posted - 2008-10-30 : 14:18:32
Hi,

I need help in finding whether a excel file exists in a shared folder in a stored procedure.

any help is appreciated.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-30 : 14:23:44
use undocumented extended stored procedure xp_fileexist

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1129944,00.html
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-31 : 03:27:00

or


EXEC master..xp_cmdshell 'dir Filepath'

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-10-31 : 06:48:42
Maybe you can make use of this stored procedure:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90490

- Lumbago
Go to Top of Page
   

- Advertisement -