Dynamically decide salesforce object name and fields in SSIS Salesforce Integration Toolkit Connector

Question

I want to know is this possible to do in SSIS Salesforce Integration Toolkit.

I have installed microsoft visual studio 2015 with SQL server data tools.

I am trying to download salesforce objects data to local SQL server 2016 database. In which I have excel sheet with two columns object name and fields (separated by comma).

So I used ForEach loop container to iterate over the list from excel sheet. And using row values I generated query string i.e. SOQL query.

I tried to provide dynamically generated SOQL query to salesforce source connection But its not working, salesforce source connection editor not taking the dynamic value instead showing error message as shown in below screenshot.

Kindly provide any valuable suggestions to resolve the issue.

I want to dynamically build SOQL query and provide this to Salesforce connector and retrieve data for all salesforce objects i.e offcourse inside loop container.

Answer 1

For the issue you are getting, can you please try to provide a default value for @[User:Fields] and @[User:Oname] to see if it makes any differences? By doing this, the component can have default fields and entity to initiate the metadata.

We would also like to mention that, since the metadata (columns in the Columns page) is defined in the design-time and cannot be changed dynamically during the runtime, so you cannot just simply change the fields in the SOQL query to update the columns during the runtime. This means that the fields need to be exactly the same for each iteration (i.e. entity).