January 28, 2005 at 10:09 am
What I have done in past is to setup a directory structure with the following directories:
IN, OUT, Work
Place the input files in the IN directory, move the file to work as the DTS is processing and then move it to OUT when processing is complete. If you use an ActiveX task (Scripting.FileSystemObject) to control the file movements, you may curbe the exception/overwrite problem. Hope this helps!
JG4SMILE.
solutions...not answers...
-->January 28, 2005 at 11:57 am
Hi,
Thanks for your reply. its source file. so its not opened by filesystemobject. the file operation will be handled by the DTS itself. only in some situation its not releasing the file. when i try this in dev or UAT environment, its working fine. so just want to make sure whether the file is released by any properties. pls let me know.
Rgds,
Ravikumar.T.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply