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
Related Articles
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 ...Where can I find the documentation for the Salesforce Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Salesforce Destination can be found at the following link. For many of the components you can find ...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 a warning message in the package event log. Please look at the screenshot below: