ETL and Data Integration tools - Modern ETL software for everyone

I need a way to schedule the following into a package. I want to do a select sum on one column in a table.
If the value is > 0;
I want to set a failure. If the value is 0, I want to set a succeed.
This is done in DTS via ActiveX component. How can I accomplish the same thing here?

Thanks,
Jennife

Use SQL data check object

Note:
Sql Data Check uses lookups to check data in the database.
For example user may write following sql
Select count(*) from table
Execution will be successful if the value of first field of lookup query is more than 0
Execution will fail if the value of first field of lookup query is equals to 0 or less than 0 or field type is not numeric.