Set-EnvironmentVariableProperty

NAME Set-EnvironmentVariableProperty



SYNOPSIS

Set the given property to a given value





SYNTAX

Set-EnvironmentVariableProperty [[-sqlConn] <SqlConnection>] [[-ssisVar] <PSObject>] [[-ssisProp] <Hashtable>]

[[-PropertyName] <String>] [[-PropertyValue] <String>] [<CommonParameters>]





DESCRIPTION

Updates a given property to a given value - if data type has been altered then we parameterName will be "Type".

If description altered then "description". These are the only two properties that can be altered.





PARAMETERS

-sqlConn <SqlConnection>



Required? false

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisVar <PSObject>

Settings of target variable



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisProp <Hashtable>

Properties of deployment (folder/project/environment)



Required? false

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-PropertyName <String>

Either description or type.



Required? false

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-PropertyValue <String>



Required? false

Position? 5

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Set-EnvironmentVariableProperty -sqlConn $sqlConnection -ssisVar $ssisVariable -ssisProp $ssisProperties

-PropertyName "Description" -PropertyValue $ssisVariable.Description



Set-EnvironmentVariableProperty -sqlConn $sqlConnection -ssisVar $ssisVariable -ssisProp $ssisProperties

-PropertyName "Type" -PropertyValue $ssisVariable.dataType











RELATED LINKS