Hello,
I am using the following syntax to launch an SSIS package from PowerShell:
Invoke-Sqlcmd | Out-Null
Set-Location SQLSERVER:\SQL
(Get-ChildItem 'SQLSERVER:\SSIS\{server running SSIS}\Default\Catalogs\SSISDB\Folders\SSIS_Packages\Projects\{Project Foldername}\Packages\' | WHERE { $_.Name -eq 'Package.dtsx' }).Execute("true", $null)
While this syntax is working fine for executing a basic package, I would now like to pass a project parameter of type string from the PowerShell script to the SSIS execution. The string value will be either "test" or "prod"
How would I do that?
Also, please note that our PowerShell scripts are run on a different server than our SSIS instance.
Thank you!