ETL and Data Integration tools - Modern ETL software for everyone

As one of the routines in my package, I would like to check to see if a SQL table is empty, or populated. If the table is empty, then the next part of the package will process. If the table has any data in it, the package will fail and abort.

I am using ELT PRocessor Pro

Frank

All you need to do is to use SQL Data Check Object.

SQL Data Check uses SQL scripts 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 query is more than 0
Execution will fail if the value of first field of query is equals to 0 or less than 0 or field type is not numeric.

Peter