question

Andy899 avatar image
Andy899 asked

Set up SSIS Logging with a Project Connection

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.
ssisssis errorssis2012connection string
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

VishalhSingh avatar image
VishalhSingh answered
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".
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

VishalhSingh avatar image
VishalhSingh answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.