Page 1 of 1

Salesforce Data Source union does not work

Posted: Fri 02 Mar 2018 01:04
by elucas
Hi,

We are trying to extract data from salesforce and are using your Devart Salesforce Source component.
Inside we have used a query with union and it looks like it does not work properly. It returns less result. If we place only one single select statement then it returns correct data but as soon as we union two or more select statements it returns incorrect number of rows.

What are we doing wrong?

Thank you

Re: Salesforce Data Source union does not work

Posted: Sat 03 Mar 2018 12:36
by Pinturiccio
Please specify which product you use: dotConnect for Salesforce or SSIS Data Flow Components for Salesforce.

Please also post here an example of a query with the Union clause that reproduces the issue and describe the steps we should perform to reproduce the issue in more details.