-
Notifications
You must be signed in to change notification settings - Fork 3
Edit SsisEnvironmentName
This executes the stored procedure "rename environment", effectively appending the current SSIS Project LSN to the name.
Edit-SsisEnvironmentName [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection>
[[-ssisFolderName] <String>] [[-ssisEnvironmentName] <String>] [-ssisProjectLsn] <String> [<CommonParameters>]
Before we re-write the values stored in an environment, we can effectively take a back up of the current environment by re-naming it. We can used the return name to revert this back to the original name if we need to rollback if a validation has failed
$ssisEnvironmentRename = Edit-SsisEnvironmentName -ssisPublishFilePath $thisSsisPublishFilePath -ssisProjectLsn $thisLsn -sqlConnection $ssisdb
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: FalseRetrieved from ISC by using Get-SsisProjectLsn function.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
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.