How to have SSIS exception in my console log

Question

I have Jenkins slave of windows server 2019. I'm running SSIS deploy command thought Powershell:

$ISDeploymentWizard = Start-Process -FilePath ISDeploymentWizard.exe -ArgumentList '/Silent','/ModelType:Project','/SourcePath:"Integration Services\\bin\\Development\\Integration Services.ispac"',"/DestinationServer:${Env}",'/DestinationPath:"/SSISDB/BAZEL/DEVOPS"' -wait -PassThru -Credential $cred
    $ISDeploymentWizard.WaitForExit()
    $ISDeploymentWizard

The issue is when I have an error, I don't see anything in my jenkins console as the silent mode is not working very well for ISDeploymentWizard. Any error in the syntax is causing a pop up window in the remote with the error. Is there any idea how can I make it appears also in my console? In the current situation, the job is just stuck at this stage, and I have to abort it manually. I also tried to use powershell timeout, but it's not working as well. any idea?

The most relevant thread I've found is this one from 2015:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/def8c8a5-9473-4e4d-8c4a-ecd71c035b3f/error-in-deploying-ispac-files-in-ssisdb-in-silent-mode?forum=sqlintegrationservices

and one alternative way suggested here also form 2015:
https://joyfulcraftsmen.wordpress.com/2015/07/31/ssis-automated-deployment-for-project-mode/

Answer 1

Hello @arielman2304

Devops is not currently supported here on Microsoft QnA. The Community Members and Engineers are actively answering questions in dedicated forums here.

Please post your question in that forum : Developer Community

Best Regards
Karlie

----------

If the Answer is helpful, please click "Accept Answer" and upvote it.