If a column is missing in your excel file when using the Excel Source Plus component, your SSIS+ package will execute successfully, but we generate generate a warning message in the package event log. Please look at the screenshot below:
If you need to modify the data types or lengths for any source columns or fields, use the Advanced editor for the component and only make changes to the Output columns. Do not make changes to the External columns. If you make changes to both the ...
Watch this video showing how to dynamically modify the Excel source filename and worksheet name at runtime. The same technique can be used for the Excel destination filename and worksheet name.
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 ...
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 ...