- SQL Server 2017 Integration Services Cookbook
- Christian Cote Matija Lah Dejan Sarka
- 256字
- 2021-07-02 20:41:29
Custom logging
This section will talk about various loggings and how we can customize logging to suit our needs in terms of logging information. The reason why we need logging is because we want to retrieve some information on our package executions.
Here are some examples of logging info we might be interested in getting:
- How much time it took to execute a specific package
- How many rows have been transferred from one transform to another in our data flows
- What were the warnings or errors that were issued by the package execution
- The new values that have been assigned to a variable in a package, and so on
All the topics listed here will be discussed in the next sections of the book. For now, we'll focus on the customized logging levels.
There are various ways that we can log package execution information in SSIS. In versions prior to 2012 (or if we opt for a Package Deployment Mode instead of the default one, the Project Deployment Mode), the only way to enable logging was to enable it in each package. If we forgot to enable it in one package, the latter would not log anything. The default Project Deployment Mode can also log using package logging, but it's better to use SSIS Catalog logging, since it's integrated with projects once deployed and SSIS built-in execution reports will use it to display package execution information.
We'll talk about the various deployment models in the next chapter, Chapter 3, Key Components of a Modern ETL Solution.
- Java程序設計與開發
- C# 7 and .NET Core Cookbook
- Java 9 Programming Blueprints
- The Data Visualization Workshop
- Corona SDK Mobile Game Development:Beginner's Guide(Second Edition)
- PLC應用技術(三菱FX2N系列)
- 微信小程序開發與實戰(微課版)
- Visual Basic 6.0程序設計實驗教程
- HTML+CSS+JavaScript網頁設計從入門到精通 (清華社"視頻大講堂"大系·網絡開發視頻大講堂)
- JBoss:Developer's Guide
- After Effects CC案例設計與經典插件(視頻教學版)
- H5頁面設計與制作(全彩慕課版·第2版)
- 樹莓派開發從零開始學:超好玩的智能小硬件制作書
- Mastering R for Quantitative Finance
- Python Business Intelligence Cookbook