Overview

Script Task for alternative SSIS package configuration setup. The configuration is contained in Excel worksheet with two columns:

• first column is path to object property to set
• second column is property value.

The script task parameters are:

• Package Connection Manager – the connection manager providing the package.
• Configuration Environment – system environment variable containing the path to the Excel configuration file.
• Configuration Worksheet – Excel worksheet containing the configuration.

Requirements

Depends on CozyRoc Script Task Plus component for implementing parameters user interface.

Depends on CozyRoc Package Connection Manager component for accessing SSIS package object.