how to know which spid corresponding to dts job fetches records from other server

• siva.l.prasad

  SSC Enthusiast

  Points: 162

  More actions

  November 6, 2008 at 1:03 am

  #70939

  hi all

  i am facing a problem i.e i am using one dts package which fetches records from another server ,i want to know which spid corresponding to this dts job in second server. i can trace it through current activity , but i need a query to know this information. any body can help..

  Thanks in advance

  siva

• JeremyE

  SSCoach

  Points: 16199

  More actions

  November 7, 2008 at 4:32 pm

  #895872

  Coss post - http://www.sqlservercentral.com/Forums/Topic597931-5-1.aspx