SQL 2012 中的 SSIS 日志记录 [英] SSIS Logging in SQL 2012

问题描述

在 2008R2 版本中，我使用 SSIS 日志记录到定义数据库中的 sysssislog 表.2012 现在带来了具有自己的 SSISDB 数据库的集成服务目录的概念.是否仍然需要使用 sysssisslog 表的日志记录，或者是现在在 SSIS 数据库中某处结束的信息(我所期望的，因为 SSIS 执行的所有报告也基于此数据库).

In the 2008R2 version I was using SSIS logging to a sysssislog table in a defined database. 2012 brings now the concept of Integration Services Catalogs that have their own SSISDB db. Is it still necessary to use the logging to sysssisslog tables or is the information that ends there now somewhere in SSIS DB (what i would expect, since all the reporting for SSIS execution is based on this db as well).

推荐答案

您熟悉的日志记录在 SQL Server 2012 版中仍然可用.也就是说，如果您使用的是项目部署模型 (SSISDB)，则不必在您的包中显式定义数据库日志记录.

The logging you are familiar with remains available to you with the 2012 release of SQL Server. That said, database logging no longer has to be explicitly defined in your package if you are using the Project Deployment model (SSISDB).

开箱即用，您将在运行包时获得基本日志记录级别.其他选项是无、性能和详细.阅读更多关于如何设置这些和其他 执行参数，来自 MVP Phil Brammer.实际 SSIS 团队的 Matt Masson 在他关于 SSIS 目录日志级别中包含哪些事件.

Out of the box, you'll get Basic logging level when you run a package. The other options are none, performance and verbsose. Read more about how to set these and other execution parameters via MVP Phil Brammer. Matt Masson of the actual SSIS team points out what events those levels correspond to in his post on What Events are Included in the SSIS Catalog Log Levels.

最后，SSIS Reporting Pack 是 MVP Jamie Thomson 的一个开源项目，它提供了对基础知识的不同见解在新的集成服务目录中捕获的数据.

Finally, SSIS Reporting Pack is an open source project from MVP Jamie Thomson that provides different insight into the basic data being captured in the new integration services catalog.

我的想法:没有必要.但是，如果您已经有一个从该日志中剔除数据的框架(我们将其用于警报系统)，则支持您继续使用它.如果您从多个服务器运行集成服务包，则没有任何功能可以将所有这些不同的 SSISDB 目录中的日志记录结合起来，以深入了解您的整个 Universe.如果您使用经典技术将所有包都登录到中央服务器，您就可以做到这一点.

My thoughts: necessary no. But if you already have a framework built out culling data from that log (we use it for an alerting system), you are supported to keep using it. If you run integration services packages from multiple servers, there is no functionality to combine the logging from all those disparate SSISDB catalogs to provide insight into your entire universe. You can get that if you all the packages log to a centralized server using the classic technique.

这篇关于SQL 2012 中的 SSIS 日志记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！