Script task for alternative SSIS package configuration setup.
The script has the following parameters:
- PackageConnection - the connection manager providing the package.
- ConfigurationEnvironment - system environment variable containing the path to the Excel configuration file.
- ConfigurationWorksheet - Excel worksheet containing the configuration.
The configuration is contained in Excel worksheet with two columns:
- first column is path to object property to set
- second column is property value.