Get-SsisProjectLsn

NAME Get-SsisProjectLsn



SYNOPSIS

Get latest project lsn. This is effectively the version number of the project.





SYNTAX

Get-SsisProjectLsn [-jsonPsCustomObject] <PSObject> [-sqlConnection] <SqlConnection> [[-ssisFolderName] <String>]

[<CommonParameters>]





DESCRIPTION

useful for when we may need to rollback, this is the latest lsn for a given project.





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



<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



NOTES





Used in rollback process, but seeing as we're not currently using that process this is not currently in use.



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>$ssisLatestProjectLsn = Get-SsisProjectLsn -ssisPublishFilePath $thisSsisPublishFilePath -sqlConnection

$ssisdb















RELATED LINKS