How to execute remote SSIS package using username and password while using dtexec utility in SQL Server

Minmoku 0 Reputation points
2023-11-28T10:39:44.01+00:00

When I use the dtexec utility (version 160 x64), can I login with a username and password instead of a Windows account? I have used the following parameters; /ISServer, /Server, /User, /Password, but I cannot successfully execute the dtsx package. How should I do this correctly? Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,343 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points
    2023-11-29T02:30:40.4033333+00:00

    Hi @Minmoku

    I would strongly advice you to ask for working SQL Agent and create an Agent Job to run the package.

    You could use Native Windows user credentials management with proxy accounts to run the packages remotely.

    You may also check:

    How to run dtexec remotely

    Regards,

    Zoe Hui


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

    0 comments No comments