Page 1 of 1

Field Not Visible In Connector

Posted: Thu 06 Oct 2016 13:16
I am trying to bring in a system field from Salesforce -- CreatedByID.

When I open the Devart Source, I can't see it.

Troubleshooting so far:
  • Hit refresh on Devart
  • Checked SF to make sure user had access to field
  • Set MetaData Refresh to true on the connector

Re: Field Not Visible In Connector

Posted: Fri 07 Oct 2016 19:27
by Shalex
The name of the Devart product you are using is "dotConnect for Salesforce", isn't it? Please set "System Objects=true;" in your connection string, refresh metadata (or remove the C:\Users\YOUR_OS_USER_NAME\AppData\Roaming\*.db files, and provider will recreate them).

Does this help? If not, specify:
1) the name ("dotConnect for Salesforce" or "SSIS Data Flow Components for Salesforce") of your product and its exact version (x.x.x)
2) the name of the Salesforce object where CreateByID is missing via interface of our product

Re: Field Not Visible In Connector

Posted: Fri 07 Oct 2016 20:09
Awesome! That worked... :D