January 27, 2005 at 7:40 pm
Dear All,
i am using DTS to update records from DTSFlatFile to oracle. there will be about 50 jobs/day. sometimes some file fails to close (i guess). the next day code will delete the existing file and download a new file.
As the file is not closed properly, its not allowed to delete and throws an exception. (exception clearly says, it is being used by another process.)
is there any option we close the file once the DTS process is complete.
But all the jobs completes and i am getting the log file properly.
Thanks in advance,
Ravikumar.T.
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply