Yesterday morning I created an SSIS PAckage that checks for the existence of a record in a table for the current date.

If the record is found the package succeeds, else the package fails.

I created a Job with the 1st Step the SSIS Package that looks for the record. For testing I set the number of entries to 5 at an interval of a minute.

I added a second SSIS task that loads the table.

If a record is found in the table the second step executes to load the data.

I did this in DTS in early 2004 but I could not remember how I did it.