Filtering data to component

[Anonymous]

Hi,

I have a job that is retrieving data from Salesforce and making an insert into another SF table based on the results of the first query.

Using tSalesforceOutputBulkExec, I see that even if no data are sent for the insert, the connection is still open to Salesforce (I can see it from the bulk query monitoring). I would like to avoid the opening of the connection if no results are found in the first query. Here below a screen of my job:

How could I set the job to continue with the tSalesforceOutputBulkExec only if there are data to transfer? Is there any way to do it directly in the tMap component, or maybe by filtering in some way the 'main'?

Thanks
Iris

[manodwhb]

@altibzz , As i understand that you need to insert if there is data in file to insert into slaesforce right. You need to use the below way.

[Anonymous]

in this way I am still opening the bulk connection, am i right? Thanks