I have a DTS package which basically does the following

1. Extracts data from AS400
2. Copies data to a table in SQL
3. Gets data from SQL and exports to a spreadsheet
4. Sends the spreadsheet as an attachment to an email to various recipients

What I really want to do, is check that records have been retrieved from the
AS400 prior to sending as an attachment...and then ONLY send the attachment
of records were returned from the AS400. So put a check in between steps 1
and 2 and, depending on the result of that check, continue or not.

I suspect I can do this using Dynamic Properties Task...but I have no idea
how. Can anyone help, pls?