I'm trying to figure out how to trace only SSIS packages accessing a database. I think one way (albeit probably not perfect) to find these queries using SQL are using sys.dm_exec_sessions and checking client_interface_name for the value "OLE DB" (at least for this database). However, I can't find the correct predicate for this in EE. Is there another way?
SQL Server 2012 SP2