Overview
Script task to refresh Excel connections and pivot tables.
Microsoft Excel must be installed in the environment where the package is executed.
Setup
The script has the following parameters:
- IsFileVariable - If true, input Excel file name is contained in package variable. Otherwise, it is a file connection manager (Boolean).
- FileVariable - Input file variable (String).
- File - Input file connection manager (Connection).
- All - If true, all connections are refreshed (Boolean).
- Timeout - Specifies the time in seconds to wait for data to refresh before closing the Excel application. The default is 100 seconds (Integer).
- Connections - Explicitly select connections to refresh.
- Worksheets - Explicitly select worksheets to refresh.
Additional information
If you receive the following error:
Microsoft Excel cannot access the file '<path>.xlsx'. There are several possible reasons: ? The file name or path does not exist. ? The file is being used by another program. The workbook you are trying to save has the same name as a currently open workbook.
This issue can be resolved by adding a Desktop folder to the following directories:
- C:\Windows\SysWOW64\config\systemprofile\
- C:\Windows\System32\config\systemprofile\
