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
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 ...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 ...Excel Destination: How to modify an Excel Destination start column dynamically at runtime
The destination start column 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 column number where you wish to begin writing in the Excel destination. ...