-
Notifications
You must be signed in to change notification settings - Fork 3
Publish SsisIspac
Publish an ispac to a project folder.
Publish-SsisIspac [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection> [-ispacToDeploy] <String>
[[-ssisFolderName] <String>] [[-ssisProjectName] <String>] [<CommonParameters>]
Publish an ispac and check that it was deployed. $ispacToDeploy is a file path. We convert into bits and pass in. Non-mandatory params here can be used to overwrite the values stored in the publish json file passed in
1)
Publish-SsisIspac -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb -ispacToDeploy $thisIspacToDeploy
2)
Publish-SsisIspac -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb -ispacToDeploy $thisIspacToDeploy -ssisFolderName "newFolder"
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: FalseFile path to ispac we want to deploy. Convert to byte object then execute as VARBINARY
Type: String
Parameter Sets: (All)
Aliases:
Required: True
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.