Hi @Peter Bishop,
You can try to use an Expression for a connection to adjust ApplicationName property value on the fly.
A couple of SSIS system variables are good candidates to be used:
- PackageID, The unique identifier of the package.
- PackageName, The name of the package.
https://learn.microsoft.com/en-us/sql/integration-services/system-variables?view=sql-server-ver16