DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
Overview
Script task for alternative SSIS package configuration setup.
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.
Requirements
Depends on COZYROC Script Task Plus for implementing parameters user interface.
Depends on COZYROC Package Connection Manager for accessing SSIS package object.