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:
0 Comments.