Actually you could do it all within same SSIS package itself. Thats the purpose of control flow engine. you can use SentMail task and link to your current sync step on failure to send error mail in case of failure. you can also add execute sql task to check count of rows and based on count determine next task to be executed by using expression based precedence constraint. So you'll just have single step in sql job and you do all control sequence action inside control flow of the package.