How can I dynamically modify the Excel source filename and worksheet name at runtime?

• Related Articles

• 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 ...

• 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 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 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 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 ...