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. This will give you an idea what format you have to follow to update those fields.Example format:
;#Corporate Strategy;#Corporate or Business Unit Growth Strategy;#
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
If our SharePoint service is MFA-enabled, does this mean we can't use the SharePoint components?
We have recently posted a way to connect to MFA-enabled service. You have to upgrade to latest 2.0 version of COZYROC in order to use this new connection for MFA-enabled service. You can see the "Quick Start" article by clicking here: ...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 ...Where can I find the documentation for the SharePoint Destination?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the SharePoint Destination 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, ...SharePoint Destination: How to modify the SharePoint Destination list dynamically at runtime
The SharePoint destination list is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination list. Right-click on the data flow canvas and ...