tSalesforceInput - Manual Query - Bulk -> NULL values - Query -> filled values

[joboro1]

Hello everybody,

I try to pull data from Salesforce via bulk query (via tSalesforceInput).
I use a "manual query", which is structured as follows:

Select Id, Contact.Id, Account.Id, Contact.Name, Contact.LastName, Contact.FirstName, Account.Name
from User 
where isactive=true
and Contactid != null

I created the corresponding schema according to the syntax, i.e. User_Contact_id, User_Account_Name etc..

If the component runs in query mode "bulk", all non-user fields are null.
If the component runs in query mode "query", all non-user fields are filled.

Is this an intended behavior and is it possible to get the bulk mode work with the manual query?

We use Integration Studio 6.4.1.

[TRF]

If you have less than 50,000 rows, don't use bulk (not necessary).

Don't why the result is different in your case.

[Fred_FM]

Hello All,

I know this is an old thread, but i encounter exactly the same problem.

The number of rows is > 500.000 and is going to increase, so non bulk query is not an option.

@Joerg Bohlen​ if you read this, did you find a solution ?

Thanks for your response