If IP address is the one u want, try using the sys.dm_exec_connections. This can be joined with Sys.SysProcesses to identify the IP address. (..... SQL 2005)

ERROR : 1

TITLE: Package Installation Wizard

------------------------------

Could not save the package "C:\Vinod\WeeklyReport.dtsx" to SQL Server "(local)".

------------------------------

ADDITIONAL INFORMATION:

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). ...