How to know currently running packages using sql query

  • Hi,

    SQL Server Management studio, provides a feature where we can check the currently running SSIS packages on the server. I need to get this information within a stored procedure code. Can we get this information by running some query in MSDB database.


  • Use SELECT * from msdb..sysdtspackages90 to get all the lists of the packages in the msdn. And i hope there might a column where u can check the status of the package. I don't have read permission in MSDB so can't tell acurately.


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply