Skip to content

Commit eba7c01

Browse files
authored
Merge pull request MicrosoftDocs#6863 from DanielAdeniji/patch-20
Update integration-services-ssis-logging.md
2 parents 9b3e776 + e9e7c82 commit eba7c01

1 file changed

Lines changed: 16 additions & 5 deletions

File tree

docs/integration-services/performance/integration-services-ssis-logging.md

Lines changed: 16 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -378,11 +378,22 @@ ms.author: chugu
378378
9. To save the updated package, click **Save Selected Items** on the **File** menu.
379379

380380
## <a name="server_logging"></a> Enable Logging for Package Execution on the SSIS Server
381-
This topic describes how to set or change the logging level for a package when you run a package that you have deployed to the [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] server. The logging level you set when you run the package overrides the package logging you configure at design time in [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)]. See [Enable Package Logging in SQL Server Data Tools](#ssdt) for more information.
382-
383-
In SQL Server **Server Properties**, under the **Server logging level** property, you can select a default server-wide logging level. You can pick from one of the built-in logging levels described in this topic, or you can pick an existing customized logging level. The selected logging level applies by default to all packages deployed to the SSIS Catalog. It also applies by default to a SQL Agent job step that runs an SSIS package.
384-
385-
You can also specify the logging level for an individual package by using one of the following methods. This topic covers the first method.
381+
382+
This topic describes how to set or change the logging level for a package when you run a package that you have deployed to the [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] server. The logging level you set when you run the package overrides the package logging you configure at design time in [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)]. See [Enable Package Logging in SQL Server Data Tools](#ssdt) for more information.
383+
384+
### To review and adjust a server's default logging level property
385+
386+
1. In the SQL Server instance, go to the package in Object Explorer.
387+
388+
2. Select **Integration Services Catalog**.
389+
390+
3. Right-click **SSISDB** and select **Properties**.
391+
392+
4. In **Catalog Properties**, look for the **Operations Log** group box and the **Service-Wide Default Logging Level** entry.
393+
394+
You can pick from one of the built-in logging levels described in this topic, or you can pick an existing customized logging level. The selected logging level applies by default to all packages deployed to the SSIS Catalog. It also applies by default to a SQL Agent job step that runs an SSIS package.
395+
396+
You can also specify the logging level for an individual package by using one of the following methods. This topic covers the first method.
386397

387398
- Configuring an instance of a package execution by using the Execute Package dialog box
388399

0 commit comments

Comments
 (0)