Hi, I am trying to set up SSIS logging in SQL Server 2012 to write log entry events to a SQL Server database, however this creates an error at runtime if the connection is configured as a Project Connection: **Error: The connection "Logging" is not found. This error is thrown by Connections collection when the specific connection element is not found.** I would prefer to use a Project Connection as this can be used by other packages.
Hi Andy899, I believe, you are sorted with this issue. Let us know if the solutions works for you. In case it did not you can still share the current status of the problem and we will be glad to help you in the best possible way.
Looks like the issue is with the database connection for logging. Ensure the connection was not renamed post creation and configuration of logging. From the error message you have posted it looks like the SSIS logger is not able to locate connection named as "Logging".