Missing objects or columns when using Salesforce Destination Component
Most likely the reason for object or column to be missing is that you are using older version of Salesforce API.
To verify which version of Salesforce API you are using please check what is showing in the Server URL field on the Salesforce
Connection Manager Advance Configuration screen. Please look at screenshot below:
I
If you are seeing "https://test.salesforce.com/services/Soap/u/20.0", then you are using version 20.0, which it's an older version.
To resolve your issue please use newer Salesforce API version.
For example:
- If you are using COZYROC SSIS+ Release 1.7 then the newest Salesforce API version you can use is version 37.
- If you are using COZYROC SSIS+ Release 1.9 then the newest Salesforce API version you can use is version 45.
To find what is the newest Salesforce API version you can use in your particular case please find the information below What's New on the following documentation page:
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Setting up Salesforce Bulk Mode with COZYROC Script Salesforce Bulk Result Transformation
When using COZYROC Salesforce components in Bulk Mode the operations are asynchronous, meaning the results are not immediately available. If needed, the status, identifiers of newly created records, and any error information can be retrieved in an ...Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...Missing fields when using SharePoint Source Component
Scenario: My custom created SharePoint fields are missing when using the SharePoint Source component Solution: A possible solution to the issue is to include the hidden fields. You should follow the steps below: Click twice on the ...How to include the missing columns when using an SOQL statement
The following concern applies to previous releases (before 1.9). Currently, all columns from the SOQL are automatically created, but in some cases, the data type of the column might not be retrieved from the results and a WSTR 250 would be assumed. ...How to know if a column is missing in my excel file when using Excel Source Plus component?
If a column is missing in your excel file when using the Excel Source Plus component, your SSIS+ package will execute successfully, but we generate generate a warning message in the package event log. Please look at the screenshot below: