How to make a DB Component not run based on a table being populated or not in DB

[Anonymous]

I have a Job that writes from MSQL Server DB into CSV Files then sent to a FTP site that runs weekly. Some of my tables don't get populated each week and I don't want to send an empty/blank csv file to the FTP Site. I have this job automated in Windows Task Scheduler, so I cannot just delete the file manually before sending to FTP site. Is there anyway in Talend to put a condition on a tMSSQLDBInput to not generate a CSV file if the table is not populated. Skip through the tMSSQLDBInput components that doesn't have data in the table, without failing the job and still generating the CSVs for tables with that

My job is setup tDBconnection -->  tMSSQLDBInput ---> tMSSQLDBOutputBulk x15 with subjobokay precedence constraint between them

Please advise

Thanks

Andrew

[manodwhb]

@sm ,I suggest you to give some table name,which is there as part of that view,it should not through null pointer exception.