Visual Studio 2022 SSIS cannot enable logging

John Eveland 10 Reputation points
2023-01-26T20:11:26.6066667+00:00

Right-click Control Flow area. Select logging. In Containers, I see Package1, that is not the name of my package. There is no checkbox next to Package1. How do I get the correct package in Containers and enable logging.

User's image

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,403 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,407 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points
    2023-01-27T05:42:44.8633333+00:00

    Hi @John Eveland

    I could re-produce the issue.

    For the SQL Server Integration Services Projects 2022 is a preview version, I'd like to suggest that you may raise the issue to Q&A here.

    Not sure if it is a known issue, hope that the product team could help us resolve it.

    Regards´╝î

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


  2. Yitzhak Khabinsky 24,561 Reputation points
    2023-01-27T14:47:10.9433333+00:00

    Hi @John Eveland,

    What you tried to do is a leftover from the SSIS 2005-2008R2 era.

    Starting from SSIS 2012 onwards logging is not anymore a design time setting in Visual Studio. It became a run-time setting on the SSIS server.

    The actual logging is happening in the SSISDB database. And there is a reporting on top of it.

    Check it out here: [https://www.mssqltips.com/sqlservertip/4034/integration-services-logging-levels-in-sql-server-2016/

    SSIS - Logging

    0 comments No comments