SQL Server 2019 SSIS DTExec Utility execution from Linux

Question

Hi,

We are using SQL Server 2019 on Linux and have few packages to be executed from shell script. For this we are using DTEXEC utility for package execution.

However, we are able to execute the package only with superuser and not with the user that we are using to execute the scripts.

Can someone let us know the pre-requisites or the privileges to be given to the normal user so that the package execution can be done with normal user rather then using superuser?

Quick inputs on this would be highly helpful for us. Thanks in advance.

Regards,
Phaneendra

Answer 1

Hi anonymous userBabuSubnivis-7461 ,

Please check if the normal user has full permissions to access to the dtexec.exe.

Please refer to dtexec Utility and An overview of the DTExec utility in SSIS.
The dtexec utility lets you load packages from these sources: the Integration Services server, an .ispac project file, a Microsoft SQL Server database, the SSIS Package Store, and the file system.
When you use the current version of the dtexec utility to run a package created by an earlier version of Integration Services, the utility temporarily upgrades the package to the current package format. However, you cannot use the dtexec utility to save the upgraded package.

Best regards,
Mona

----------

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.