irfankhanpatha via SQLMonster.com wrote:

> Do error trapping the same by using err.number . If the file is in
> use than skip the deleting process. You can delete the same file the
> next time when u run function (That means at the starting of the
> function before using the file.).

Stijn Verrept wrote:
>I read import a text file and need to delete it afterwards. I don't
>know any VBScript so I had to look up some code to delete it. I found
>the following:
>
>'**********************************************************************
>' Visual Basic ActiveX Script
>'***********************************************************************
>*
>Option Explicit
>
>Function Main()
> Dim oFSO
> Dim sSourceFile
>
> Set oFSO = CreateObject("Scripting.FileSystemObject")
>
> sSourceFile = "C:\Output.txt"
>
> ' Check if file exists to prevent error
> If oFSO.FileExists(sSourceFile) Then
> oFSO.DeleteFile sSourceFile
> End If
>
> ' Clean Up
> Set oFSO = Nothing
>
> Main = DTSTaskExecResult_Success
>End Function
>
>However, it could be that the file is locked and the delete fails. In
>that case I need the DTS package to sleep for a couple of seconds and
>then try again. How do I do this?
>
>Thanks in advance,
>