-
Notifications
You must be signed in to change notification settings - Fork 3
Publish SsisEnvironment
If it doesn't exist, publish environment
Publish-SsisEnvironment [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection>
[[-ssisFolderName] <String>] [[-ssisEnvironmentName] <String>] [[-ssisEnvironmentDescription] <String>]
[<CommonParameters>]
Before we can publish variables and environment references, we will need to create an environment uses publish json file to get values required Non-mandatory params here can be used to overwrite the values stored in the publish json file passed in
1)
Publish-SsisEnvironment -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb
2)
$envName "bob"
Publish-SsisEnvironment -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb -ssisEnvironmentName $envName
Tested json object loaded from Import-Json
Type: PSObject
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThe SQL Connection to SSISDB
Type: SqlConnection
Parameter Sets: (All)
Aliases:
Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseOptional parameter. We may wish to override the value of what is in the json file.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseOptional parameter. We may wish to override the value of what is in the json file.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 4
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseOptional parameter. We may wish to override the value of what is in the json file.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.