When a SQL environment has an SSIS package with multiple connection managers connecting to multiple databases, it becomes tough to pin point a connection manager in SQL profiler.

So it is advisable to set the property of Application Name within the connection manager properties as below: