Share via

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,888 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 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 25,731 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