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 2000 Forums
 Transact-SQL (2000)
 creating sript for file open

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-03-30 : 13:58:23
Hi all,

I am having trouble creating this. I have job that runs DTS from excel to sal but the whenever file is open it does not let job run and it fails. is it possible to ceate function or script to check wther the file is open or not if open then just skip the process?

thanks
   

- Advertisement -