Target server version is set to SQL Server 2019.
We use a third party tool 'ControlM' to create jobs, execute them since we have hundreds of jobs which run everyday so the ask is to run the job thru the tool which calls 'C:\program files (x86)\Microsoft SQL Server\150\DTS\Binn\dtexec.exe'
How it is not working from command line?
I changed the service acct of integration service to run under the acct which has admin rights to all test servers. The job runs successfully when creating an agent job, calling the package but not from command line.
What am I missing?