Salesforce Data Source union does not work

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
elucas
Posts: 1
Joined: Fri 02 Mar 2018 00:45

Salesforce Data Source union does not work

Post by elucas » Fri 02 Mar 2018 01:04

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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Salesforce Data Source union does not work

Post by Pinturiccio » Sat 03 Mar 2018 12:36

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.

Post Reply