I am creating Release for my SSIS project in Azure DevOps using YML file and I am using POWERSHELL on target machine task to execute my powershell code, My release pipeline is succeeding with no error. But When I go to SSISDB to check if my package is deployed I don't found any package. Can somebody tell me if I am missing something?
I checked my logs for the same task, i see below log
2021-02-04T12:23:19.5826923Z VERBOSE: JobId: '2', JobState: 'running', ComputerName: 'sj4XXXXXXXX.ad.abc.net'
2021-02-04T12:23:19.5834233Z ================================================ sj4XXXXXXXX.ad.abc.net ================================================
2021-02-04T12:23:19.6088517Z ##[command]& 'C:WINDOWSSystem32WindowsPowerShellv1.0powershell.exe' -NoLogo -NoProfile -NonInteractive
2021-02-04T12:23:19.6089023Z -ExecutionPolicy Unrestricted -Command ".
2021-02-04T12:23:19.6089342Z 'C:UsersNPJ4-SPBI-SRV-TAppDataLocalTemp2dd218e-f80b-44f3-8f5e-5149b08d0f2e.ps1'"
2021-02-04T12:23:19.6089616Z
2021-02-04T12:23:19.6915353Z & : The term 'C:Program Files (x86)Microsoft SQL Server110DTSBinnISDeploymentWizard.exe' is not recognized as the
2021-02-04T12:23:19.6915828Z At line:1 char:1
2021-02-04T12:23:19.6916147Z + & 'C:WINDOWSSystem32WindowsPowerShellv1.0powershell.exe' -NoLogo ...
2021-02-04T12:23:19.6916448Z + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2021-02-04T12:23:19.6916828Z + CategoryInfo : NotSpecified: (& : The term 'C...cognized as the:String) [], RemoteException
2021-02-04T12:23:19.6917170Z + FullyQualifiedErrorId : NativeCommandError
2021-02-04T12:23:19.6917360Z
2021-02-04T12:23:19.6917440Z
2021-02-04T12:23:19.7109786Z name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was include
2021-02-04T12:23:19.7110227Z d, verify that the path is correct and try again.
2021-02-04T12:23:19.7110626Z At P:ReleaseSmartFormsDeploymentScriptsReleaseScriptsDeploy.ISPAC.ps1:25 char:4
2021-02-04T12:23:19.7111235Z + & 'C:Program Files (x86)Microsoft SQL Server110DTSBinnISDep ...
2021-02-04T12:23:19.7111436Z
2021-02-04T12:23:19.7112075Z
2021-02-04T12:23:19.7232507Z + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2021-02-04T12:23:19.7232747Z
2021-02-04T12:23:19.7232922Z
2021-02-04T12:23:19.7360151Z + CategoryInfo : ObjectNotFound: (C:Program File...ymentWizard.exe:String) [], CommandNotFoundException
2021-02-04T12:23:19.7360501Z
2021-02-04T12:23:19.7360805Z
2021-02-04T12:23:19.7480199Z + FullyQualifiedErrorId : CommandNotFoundException
2021-02-04T12:23:19.7480492Z
2021-02-04T12:23:19.7480804Z
2021-02-04T12:23:19.7605182
question from:
https://stackoverflow.com/questions/66047530/ssis-package-is-not-deploying-to-server-via-release-pipeline-in-azure-devops 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…