Excel Source Plus: How to modify the source region dynamically at runtime
The source region 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 region. The variable should be a string and the order should be: start column, start row, end column, end row. '-1' means read all the columns or rows.
- 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: [Excel Source Plus].[Region]. This is the property containing the region. The format of this parameter is: Start column, Start row, Number of columns, Number of rows.
- 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
Excel Source Plus: How to modify the worksheet name dynamically at runtime
The source 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 worksheet name. Right-click on the data flow canvas and select ...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. ...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. ...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 ...LDAP Source: How to modify the filter dynamically at runtime
The filter 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 filter. Right-click on the data flow canvas and select the Properties menu. Scroll ...