-
Notifications
You must be signed in to change notification settings - Fork 3
Publish SsisEnvironmentReference
If it doesn't exist, create a reference between a project and environment and check it exists..
Publish-SsisEnvironmentReference [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection>
[[-ssisFolderName] <String>] [[-ssisEnvironmentName] <String>] [[-ssisProjectName] <String>]
[<CommonParameters>]
Create a reference between an environment and a project We can then associate variables in an environment to parameters in a project 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 created.
Publish-SsisEnvironmentReference -ssisPublishFilePath $thisSsisPublishFilePath -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: 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.