< Back
Unpublish-SsisEnvironment
Post
NAME Unpublish-SsisEnvironment
SYNOPSIS
If exists, delete an environment that has been published
SYNTAX
Unpublish-SsisEnvironment [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection> [[-ssisFolderName]
<String>] [[-ssisEnvironmentName] <String>] [<CommonParameters>]
DESCRIPTION
We may wish to remove an environment, especially if an environment is part of a validation that has failed.
This function will check if an environment exists, and if it does, it will delete it.
Non-mandatory params here can be used to overwrite the values stored in the publish json file passed in
It will verify that it is deleted.
PARAMETERS
-jsonPsCustomObject <PSObject>
Tested json object loaded from Import-Json
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-sqlConnection <SqlConnection>
The SQL Connection to SSISDB
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ssisFolderName <String>
Optional parameter. We may wish to override the value of what is in the json file.
Required? false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ssisEnvironmentName <String>
Optional parameter. We may wish to override the value of what is in the json file.
Required? false
Position? 4
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:\\>Unpublish-SsisEnvironment -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb
RELATED LINKS
SYNOPSIS
If exists, delete an environment that has been published
SYNTAX
Unpublish-SsisEnvironment [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection> [[-ssisFolderName]
<String>] [[-ssisEnvironmentName] <String>] [<CommonParameters>]
DESCRIPTION
We may wish to remove an environment, especially if an environment is part of a validation that has failed.
This function will check if an environment exists, and if it does, it will delete it.
Non-mandatory params here can be used to overwrite the values stored in the publish json file passed in
It will verify that it is deleted.
PARAMETERS
-jsonPsCustomObject <PSObject>
Tested json object loaded from Import-Json
Required? true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters? false
-sqlConnection <SqlConnection>
The SQL Connection to SSISDB
Required? true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ssisFolderName <String>
Optional parameter. We may wish to override the value of what is in the json file.
Required? false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-ssisEnvironmentName <String>
Optional parameter. We may wish to override the value of what is in the json file.
Required? false
Position? 4
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:\\>Unpublish-SsisEnvironment -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb
RELATED LINKS