Very Computer

>> Hi.

>> I'm using an activex script task to loop thru all the
>> files in a given folder and do some processing. I'm
having
>> issues when the file is empty(size = 0) and I can't
>> deleted from dts(vbscript).

>> Here is my code:
>> Set oFolder = oFSO.GetFolder(sPath)
>> Set oFileCollection = oFolder.Files
>> For Each oFile in oFileCollection
>>         sString =  oFile.name
>> if oFile.Size = 0 then
>> testrz = "\\Athena\Clarify_Imports\" & sString
>> if (oFso.FileExists(testrz)) then
>>    oFso.DeleteFile(testrz)
>> end if
>>     end if
>> Next

>> 'The deleteFile is NOT WORKING..is not deleting a file..
>> 'If you have any ideas please let me know
>> 'I also try the move method to move the file to an
>> archive 'directoy but it doesn't either..
>> 'I have permissions for the folder..the process works if
>> the file has data !! PLease Help!! RZ

>.

> Step Error Source: Microsoft Data Transformation Services
> (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft VBScript runtime error
> Error Description: Permission denied

> Error on Line 80
> line 80 is where i'm using deletefile.

> >-----Original Message-----
> >RZ try...
> >oFSO.DeleteFile testrz, True
> >JFB

> >> Hi.

> >> I'm using an activex script task to loop thru all the
> >> files in a given folder and do some processing. I'm
> having
> >> issues when the file is empty(size = 0) and I can't
> >> deleted from dts(vbscript).

> >> Here is my code:
> >> Set oFolder = oFSO.GetFolder(sPath)
> >> Set oFileCollection = oFolder.Files
> >> For Each oFile in oFileCollection
> >>         sString =  oFile.name
> >> if oFile.Size = 0 then
> >> testrz = "\\Athena\Clarify_Imports\" & sString
> >> if (oFso.FileExists(testrz)) then
> >>    oFso.DeleteFile(testrz)
> >> end if
> >>     end if
> >> Next

> >> 'The deleteFile is NOT WORKING..is not deleting a file..
> >> 'If you have any ideas please let me know
> >> 'I also try the move method to move the file to an
> >> archive 'directoy but it doesn't either..
> >> 'I have permissions for the folder..the process works if
> >> the file has data !! PLease Help!! RZ

> >.

>> Thanks JFB. I try that but that didn't work.
>> I'm getting this error:

>> Step Error Source: Microsoft Data Transformation
Services
>> (DTS) Package
>> Step Error Description:Error Code: 0
>> Error Source= Microsoft VBScript runtime error
>> Error Description: Permission denied

>> Error on Line 80
>> line 80 is where i'm using deletefile.

>> >-----Original Message-----
>> >RZ try...
>> >oFSO.DeleteFile testrz, True
>> >JFB

>> >> Hi.

>> >> I'm using an activex script task to loop thru all the
>> >> files in a given folder and do some processing. I'm
>> having
>> >> issues when the file is empty(size = 0) and I can't
>> >> deleted from dts(vbscript).

>> >> Here is my code:
>> >> Set oFolder = oFSO.GetFolder(sPath)
>> >> Set oFileCollection = oFolder.Files
>> >> For Each oFile in oFileCollection
>> >>         sString =  oFile.name
>> >> if oFile.Size = 0 then
>> >> testrz = "\\Athena\Clarify_Imports\" & sString
>> >> if (oFso.FileExists(testrz)) then
>> >>    oFso.DeleteFile(testrz)
>> >> end if
>> >>     end if
>> >> Next

>> >> 'The deleteFile is NOT WORKING..is not deleting a
file..
>> >> 'If you have any ideas please let me know
>> >> 'I also try the move method to move the file to an
>> >> archive 'directoy but it doesn't either..
>> >> 'I have permissions for the folder..the process
works if
>> >> the file has data !! PLease Help!! RZ

>> >.

>.

> Hi JFB
> How can I find out the default user account that dts is
> using so I can provide the priviles to read write etc?
> I'm using sql server 7 by the way
> Thanks again! RZ
> >-----Original Message-----
> >Aaaaaa...
> >You don't have permission to delete files on you
> network...
> >JFB

> >> Thanks JFB. I try that but that didn't work.
> >> I'm getting this error:

> >> Step Error Source: Microsoft Data Transformation
> Services
> >> (DTS) Package
> >> Step Error Description:Error Code: 0
> >> Error Source= Microsoft VBScript runtime error
> >> Error Description: Permission denied

> >> Error on Line 80
> >> line 80 is where i'm using deletefile.

> >> >-----Original Message-----
> >> >RZ try...
> >> >oFSO.DeleteFile testrz, True
> >> >JFB

> >> >> Hi.

> >> >> I'm using an activex script task to loop thru all the
> >> >> files in a given folder and do some processing. I'm
> >> having
> >> >> issues when the file is empty(size = 0) and I can't
> >> >> deleted from dts(vbscript).

> >> >> Here is my code:
> >> >> Set oFolder = oFSO.GetFolder(sPath)
> >> >> Set oFileCollection = oFolder.Files
> >> >> For Each oFile in oFileCollection
> >> >>         sString =  oFile.name
> >> >> if oFile.Size = 0 then
> >> >> testrz = "\\Athena\Clarify_Imports\" & sString
> >> >> if (oFso.FileExists(testrz)) then
> >> >>    oFso.DeleteFile(testrz)
> >> >> end if
> >> >>     end if
> >> >> Next

> >> >> 'The deleteFile is NOT WORKING..is not deleting a
> file..
> >> >> 'If you have any ideas please let me know
> >> >> 'I also try the move method to move the file to an
> >> >> archive 'directoy but it doesn't either..
> >> >> 'I have permissions for the folder..the process
> works if
> >> >> the file has data !! PLease Help!! RZ

> >> >.

> >.