Publish-SsisIspac

NAME Publish-SsisIspac



SYNOPSIS

Publish an ispac to a project folder.





SYNTAX

Publish-SsisIspac [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection> [-ispacToDeploy] <String>

[[-ssisFolderName] <String>] [[-ssisProjectName] <String>] [<CommonParameters>]





DESCRIPTION

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





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



-ispacToDeploy <String>

File path to ispac we want to deploy. Convert to byte object then execute as VARBINARY



Required? true

Position? 3

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? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisProjectName <String>

Optional parameter. We may wish to override the value of what is in the json file.



Required? false

Position? 5

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:\\>1)



Publish-SsisIspac -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb -ispacToDeploy

$thisIspacToDeploy

2)

Publish-SsisIspac -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection $ssisdb -ispacToDeploy

$thisIspacToDeploy -ssisFolderName "newFolder"











RELATED LINKS