官术网_书友最值得收藏!

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.

主站蜘蛛池模板: 临海市| 聂拉木县| 正定县| 商河县| 沁水县| 墨脱县| 定州市| 宁乡县| 武强县| 梁河县| 浠水县| 仲巴县| 额尔古纳市| 张北县| 武义县| 迭部县| 沙河市| 武功县| 新化县| 平潭县| 邵阳市| 定远县| 桑植县| 五家渠市| 安吉县| 夹江县| 黄大仙区| 嫩江县| 昆山市| 马龙县| 咸丰县| 周宁县| 湾仔区| 峨眉山市| 灵山县| 凤翔县| 台前县| 杂多县| 万山特区| 治县。| 中宁县|