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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-07 : 07:04:27
|
| Francisco Miranda Campillo writes "Hi, we have the next scenarioOS Windows 2003 Enterprise EditionSQL MS-SQL 2000 Enterprise Edition SP3We have a DTS that get several zip - unzipped the dbf files and make the transformation of these dbf to Tables in an SQL DataBase, until here all is happy and correct, but we have the need to delete the DBF files after we get the next zip to ensure that all DBF files are from the same zip.When we are trying to delete these DBF via an ActiveX command, sometimes run well and other times we get the Access Denied error when trying to delete it.We have activate in all the transformation tasks the Close Connection on Completion, but not always we can delete the file, are we missing something ?We are a little desesparte, we have working around with these problem about 3 weeks and we dont found why, and when..Thanks in AdvantageFrancisco MirandaBI Consultorwww.gopac.com.mx" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-08 : 01:28:51
|
all i can say is that it's a sharing violation, somebody must be using the files or atleast viewing themcoz you said that sometimes it works and other times it doesn'tsorry for such a small contribution  --------------------keeping it simple... |
 |
|
|
|
|
|
File Delete Access Deneid