Get Environment Variable Task

Your rating: None Average: 2 (1 vote)
Script File: 
GetEnvironmentVariableTask.2005.stx
GetEnvironmentVariableTask.2008.stx10
GetEnvironmentVariableTask.2012.stx11

Overview

Retrieves environment variable. The result is stored in specified ResultVariable package variable.

Requirements

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

Library references

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

ScriptMain

»

This capability is built into SSIS

Submitted by Anonymous on Thu, 07/03/2008 - 16:15.

You can load environment variables into package variables using indirect configurations. No need for a custom task.

TechEd'13

June 3 - 6, 2013 New Orleans Morial Convention Center in New Orleans, LA

COZYROC will be exhibiting at the Microsoft's Premier Event for IT Professionals & Enterprise Developers. Visit COZYROC at booth #2405 and say HI.