Hi,
we used to run sp_who2 to get the active process.
we come to know form the Program Name field a DTS Package is executing.
By using DBCC Inputbuffer(spid) we get only the sqlstatement of the DTS Package.
we want to know the Name of the DTS Package which contains this sql statement.
Hoping that everyone got the scene Please help with it.