question

PhaneendraBabuSubnivis-7461 avatar image
0 Votes"
PhaneendraBabuSubnivis-7461 asked Monalv-msft edited

SQL Server 2019 SSIS DTExec Utility execution from Linux

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi anonymous userBabuSubnivis-7461 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·