Skip to content

Set ObjectParameterValue

Richie Lee edited this page May 15, 2020 · 1 revision

external help file: AssistDeploy-help.xml Module Name: AssistDeploy online version: schema: 2.0.0

Set-ObjectParameterValue

SYNOPSIS

Sets value of parameter to environment variable.

SYNTAX

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

DESCRIPTION

Sets value of either project or package level parameter to environment variable. Loops through all params of environment variable.

EXAMPLES

EXAMPLE 1

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

PARAMETERS

-sqlConn

{{ Fill sqlConn Description }}

Type: SqlConnection
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ssisVar

Settings of target variable

Type: PSObject
Parameter Sets: (All)
Aliases:

Required: False
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ssisProp

Properties of deployment (folder/project/environment)

Type: Hashtable
Parameter Sets: (All)
Aliases:

Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

NOTES

RELATED LINKS