DI Run Table Loader Only If Table Isnt Empty

[mike73]

I would like to run a table loader transformation only if the source table is not empty. I've tried playing around with Conditional Start but I cannot get anything to work.

Reason:

We have a source table coming from SQL which is having minor issues currently and our SAS source table will sometimes contain 0 rows, a job on auto scheduler runs and replaces destination table with these 0 rows and this causes problems later on (VA etc). Until this other issue is sorted we would like to only run this loader if rowcount > 0.

 

[LinusH]

I think you need som kind of user written code that check the source for no of records. You could put this in a User Written node, and then use Conditional Start to check the result from there, or just terminate the SAS session directly.