I have the below deploy command which is working from my CMD (with no popup screen):
ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:"Integration Services\bin\Development\Integration Services.ispac" /DestinationServer:"TEST,1234" /DestinationPath:"/SSISDB/TEST/DEVOPS"
but when I'm running it thought Jenkins on windows server slave:
bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\"Integration Services\\bin\\Development\\Integration Services.ispac\" /DestinationServer:\"TEST,1234\" /DestinationPath:\"/SSISDB/TEST/DEVOPS\""
I get this exception:
Unhandled Exception: System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.NetEnterpriseServers.ExceptionMessageBox.Show(IWin32Window owner)
at Microsoft.SqlServer.IntegrationServices.Wizard.Common.WizardMessageBox.Show(Exception error)
at Microsoft.SqlServer.IntegrationServices.Deployment.Program.Main(String[] args)
From what I read, this is probably due to popup screen which happens on the remote, but from the other hand, both commands are exactly the same
