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 select the Properties menu.
- Scroll down and find the properties in the group called Misc.
- Note the name of the property you want to modify dynamically at runtime. It will be named something like this: [SharePoint Destination].[DestinationList]. This is the property containing the destination list.
- Scroll down and find the Expressions property. Set up an expression for the property noted above using a variable to modify it dynamically at runtime.
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
REST Destination: How to modify the REST DestinationResource parameter dynamically at runtime
The DestinationResource parameter 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 resource. Right-click on the data flow canvas ...REST Destination: How to modify the REST ExtendMetadata parameter dynamically at runtime
The ExtendMetadata parameter 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 custom metadata for the destination. Right-click on the data flow canvas and ...Excel Destination: How to modify an Excel Destination start row dynamically at runtime
The destination start row 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 row number where you wish to begin writing in the Excel destination. ...SugarCRM Destination: How to modify a SugarCRM Destination module dynamically at runtime
The destination module 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 module. Right-click on data flow canvas and select ...Excel Destination: How to modify the Excel Destination worksheet name dynamically at runtime
The destination worksheet name 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 worksheet. Right-click on data flow canvas and ...