Get Environment Variable Task

DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
No votes yet

Script File: 
GetEnvironmentVariableTask.2005.stx
GetEnvironmentVariableTask.2008.stx10
GetEnvironmentVariableTask.2012.stx11
GetEnvironmentVariableTask.2014.stx12

Overview

Script task to retrieve environment variable.

Setup

The result is stored in specified ResultVariable package variable.

Requirements

Depends on COZYROC Script Task Plus for implementing parameters user interface.

Library references

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

ScriptMain