Find last execution time of SSIS packages in SSIS 2005

• santhoshmj84

  SSC Enthusiast

  Points: 113

  More actions

  August 17, 2017 at 9:17 am

  #324977

  Hi All,

  I am trying to find out the last execution time of DTS/SSIS packages on a SSIS 2005 server, by enabling trace on the sp "sp_dts_getpackage".While it gives results for DTS packages, it does not capture any executions of SSIS packages. Can someone confirm if the same sp "sp_dts_getpackage" is used for calling both DTS and SSIS packages in 2005 version ? 

  Also, since the logs are not enabled in the packages, is there any other way similar to above to find the running packages in SSIS 2005 ?

  Thanks,
  Santhosh

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 21, 2017 at 4:52 am

  #1955960

  Santhosh

  Have you tried looking in the sysdtslog90 table?  It's a while since I used it, but I think it's in msdb.

  John