SQL Server 2019 SSIS DTExec Utility execution from Linux

asked 2021-03-31T05:02:15.947+00:00
Phaneendra Babu Subnivis 41 Reputation points

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,840 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-03-31T07:31:10.047+00:00
    Monalv-MSFT 5,686 Reputation points

    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.