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 SharePoint Source Component to get the SharePoint Source Editor to open.
- Check the "Include Hidden Fields" box. Look at the screenshot below:
- Click the button "OK" to close the SharePoint Editor
- Verify that the missing fields showed up
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
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:Where can I find the documentation for the SharePoint Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the SharePoint Source can be found at the following link. For many of the components you can find ...Error Message: 'The remote server returned an error (429)' when using Sharepoint Online.
Summary: The error 429 is related to throttled or blocked in Sharepoint Online when sending too many requests as mentioned here Avoid getting throttled or blocked in Sharepoint Online. SharePoint Online API requests occasionally return a 429 error, ...How to pass a multiple choices to a MULTI-CHOICE SharePoint Column?
Scenario: You have a package with a SharePoint Destination Component and you are trying to map multi-select option set to a multi-choice SharePoint column. Solution: You should use SharePoint Source component to retrieve multi-choice fields from ...SharePoint - Error Message: Object Reference not set to an instance of an object.
Action: We started getting an error from a component which copies a file to an Office 365 SharePoint site. This upload has been working fine for months and no deployments have been made to it. The error is happening both on the deployed version and ...