• chandan_jha18 (4/19/2011)


    sqldba_icon (4/18/2011)


    Thanks. None of your queries gave me list of currently running packages (:. In the second query, you do not have any column referring to SSIS package? I do see some packages running under the "Running Packages" folder in SSIS. We are on sql 2005. Are you sure this query worked for you in finding currently executing packages?

    Use a profiler trace to capture what is hitting your server and it will give you a hostname too. From there you can find out how these packages are being executed and from where.

    Oh yeah for sure i could do that :). Just wanted to avoid using trace, i am so surprised there isnt a query to find running SSIS packages on a server?