Invoke-ValidateSsisProject

NAME Invoke-ValidateSsisProject



SYNOPSIS

After a deployment of the folder/environment/variables/ispac/environment reference, run a validate project.





SYNTAX

Invoke-ValidateSsisProject [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection> [[-ssisFolderName]

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





DESCRIPTION

We may wish to validate that the dtsx packages in a project will run successfully

This function will run a validation and return a validation status.

Any validation status other than 7 means something has gone wrong.

The function checks the status itself and will return an error if status is not 7.

We can use the output from this function to run other functions to rollback deployment (ie if $status -ne

"suceeded")

{

Unpublish-SsisDeployment

undo-ssisEnvironmentReference

Unpublish-SsisEnvironment

Edit-SsisEnvironmentName

}

This assumes you have run "unpublish-environmentReference" and "edit-ssisEnvironmentName" prior to deployment

I am not a huge fan of roling back, but the functionality exists in this module if people want to use it.





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



-ssisProjectName <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



-ssisEnvironmentName <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:\\>$validationStatus = Invoke-ValidateSsisProject -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection

$ssisdb















RELATED LINKS