Query dtexec package executions

Simone Bottani 0 Reputation points
2024-07-29T07:11:08.7466667+00:00

We have a SQL Server where several packages are executed using dtexec, and I would like to retrieve the execution information and from which machines they are executed, but I can’t figure out where to find it. In the executions view, there are only the packages deployed in the Integration Service Catalog, not those executed with dtexec. Do you know how to retrieve this information?

Thanks in advance

Simone

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,375 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,556 Reputation points
    2024-07-29T07:21:00.2533333+00:00

    Hi @Simone Bottani,

    Here is a same thread on Q&A, you may take a reference to.

    Find which computer ran an SSIS package

    Regards,

    Zoe Hui


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