powershell - SSIS Package is not deploying to server via release pipeline in Azure devops

Question

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

Answer 1

Waitting for answers