Post reply

How to know currently running packages using sql query

  • August 4, 2008 at 9:07 am

    #191976

    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.


    erajendar

  • August 4, 2008 at 1:51 pm

    #852896

    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.

    thanks

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

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