What's all this Application Name=SSIS-Gather_Server_and_Database_Information-{30870F9F-B4A8-4EFF-B6C9-0C2DFB43480E} nonsense?!
Application Name is just an attribute that is part of the Connection String to SQL Server protocol which identifies the application that is connected to SQL Server, for example you can retrieve the list of applications connected to a server through the following DMV:
SELECT program_name
FROM sys.dm_exec_sessions
The GUID at the end of the name is just an ID that identifies that SSIS package. You'll find it in the Properties of the SSIS package under ID.
For a full list of keywords allowed within a connection string, check this out:
http://msdn.microsoft.com/en-us/library/ms130822.aspx
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding