Average: 4 (2 votes)


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.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.XML

ScriptMain