Hi!

So, if the file byte size is zero (first task), I need the entire
package to be exit (dont do anything else). I am using this ActiveX
script:

Function Main()

Dim fso, filepath, filesize

Set fso = CreateObject("Scripting.FileSystemObject")

Set filepath = fso.GetFile("c:\foobar\blah.txt")

filesize = filepath.Size
MsgBox(filesize)

If filesize = 0 Then

'QUIT
Else
' Go to the next task which is Execute SQL task
Main = DTSTaskExecResult_Success

End If
End Function

This script is giving the correct file size but I dont know how to exit
from the entire package (or skip all other tasks)? Can anyone help?

Thanks for your help.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Main = DTSTaskExecResult_Failure

"F HS" wrote:

MJ,

It works but at the same time it is giving me an error message saying
"The task reported failure on execution". Any idea how to handle this?
In my DTS pcakage, after this ActiveX script task, I have set up two
"Execute SQL" tasks. One is with the success work flow (file size = 0,
do a dummy query) and one is with the failure work flow (do actutal
query whihc is exec stored proc).

Thanks,




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In message <#o$zUXThEHA.3024 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, F HS
<far_far (AT) hotmail (DOT) com> writes
Use a workflow script instead, e.g.

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

If you want the package to exit gracefully you have to implement workflow.

If success then
execute tasks
else
do not execute task
end if



"F HS" wrote: