What’s in a Program Name?

                While monitoring an SSIS package I noticed that the program_name
that was being displayed in the dynamic management view sys.dm_exec_sessions was “SSIS-Package-{########-####-####-####-############}ConnectionManagerName”. 
I began reviewing the package properties specifically the package name and found that the program name being returned was actually from one of the connection managers within the package, just a caveat this was an SSIS 2008 package not 2012.  I began testing to
replicate this behavior in an SSIS 2012 package and was not able to. 

              Reviewing the offending package I found that the package name, connection manager names, and task names did not contain a GUID or even resemble the program_name.  I viewed the xml of the package and found the program_name that was being shown in the sys.dm_exec_sessions was found in the connection string properties

DTS:PropertyDTS:Name=“ConnectionString”>Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Provider=SQLNCLI10.1;Integrated
Security=SSPI;Auto Translate=False;Application Name=
SSIS-Package-{########-####-####-####-############}ConnectionManagerName;</DTS:Property>

Ta Da!!  I changed the value to reflect the name that better described the package and after
re-running the package and again querying the DMV I found the program_name was returning the new value I entered.  After review of several 2012 SSIS package I did not find the Application Name proeprty in the XML, so I am under the impression that this is specific to SSIS 2005 to 2008.

 

 

 

Leave a Reply


Hit Counter provided by Sign Holders