Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Package on Failure

Author  Topic 

kshinningstr
Starting Member

24 Posts

Posted - 2005-12-08 : 15:04:20
Hello,
I have this ActiveX Script that basically checks for the file size. The simple scripts is below:

Function Main()

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile("\\xxxxxxxx\xxx\xxxx\xxxx.txt")

If objFile.Size >0 Then
main = DTSTaskExecResult_success
else
main = DTSTaskExecResult_failure
end if

End Function

I want to Quit the Package without generating errors if the task fails. How can I implement that?
   

- Advertisement -