Precedence Constraint failure help

[nc297]

I have set up a Precedence Constraint on my SSIS Package. I added a script task and added this script:

Public Sub Main()

Dim fi As System.IO.FileInfo
fi = New System.IO.FileInfo("\\sb25\downloads$\Offsets\SSISDiaries.txt")


If fi.LastWriteTime.Date = DateTime.Today Then
Dts.TaskResult = Dts.Results.Success
Else
Dts.TaskResult = Dts.Results.Failure
End If


Next I added a Precedence Constraint to my SSIS package and configured it as such:

Evaluation operation = Constraint
Value = Success

Now I want to set up something if it's fails. How do I do that?

 

[nc297]

Okay finally got it all to work.

Here's the Script Task I used in SSIS:

Public Sub Main()

Dim fi As System.IO.FileInfo
fi = New System.IO.FileInfo("\\sb25\downloads$\Offsets\SSISDiaries.txt")

If fi.LastWriteTime.Date = DateTime.Today Then
Dts.TaskResult = Dts.Results.Success
Else
Dts.TaskResult = Dts.Results.Failure
End If


Then I added a Precedence Constraint to my SSIS package and configured it as:

Evaluation operation = Constraint
Value = Success

I built the SSIS Package, went into D:/location/bin/deployment and executed that deployment package. I next imported my SSIS package in SQL Server, created a job and scheduled it to run. I next went to notifications and added my email info (Oh I added myself as an Operator so I can receive emails).