New-ssisVariable

NAME New-ssisVariable



SYNOPSIS

Drops Environment variable if it exists and creates an environment variable





SYNTAX

New-ssisVariable [[-sqlConn] <SqlConnection>] [[-ssisVar] <PSObject>] [[-ssisProp] <Hashtable>]

[<CommonParameters>]





DESCRIPTION

Internal function

Checks if a variable exists, and if it does then it drops and creates a new one.

Used where we need to create a new variable, or where data type and value have changed at same time (easier to

drop and re-create when this has occured).





PARAMETERS

-sqlConn <SqlConnection>

connection to SSIS Server



Required? false

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisVar <PSObject>

The target variable we want to create/re-create



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisProp <Hashtable>

The properties (ie folder/project/environment name)



Required? false

Position? 3

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:\\>See PublishSsisVariables for full context



New-SsisVariable -sqlConn $sqlConnection -ssisVar $ssisVariable -ssisProp $ssisProperties











RELATED LINKS