Hi, Does anyone know how to get list of DTS packages on a SQL server along with login information. Thank You Sadbhaw
Use msdb..sp_enum_dtspackages and kindly post query in relevant forum. _________ Satya SKJ Moderator SQL-Server-Performance.Com