You'll need to use variables to store the date of each backup and then use those variables together with precedence constraints to route your logic accordingly. You don't need to use a script task for this, but more to the point, you don't need to use SSIS for this - a stored procedure can encapsulate all of the logic that you need.

Regards

Lempster