Building Custom Tasks for SQL Server Integration Services: The Power of .Net for Etl for SQL Server 2019 and Beyond (Paperback)

Leonard, Andy

Building Custom Tasks for SQL Server Integration Services: The Power of .Net for Etl for SQL Server 2019 and Beyond (Paperback)
  • 出版商: Apress
  • 出版日期: 2021-02-18
  • 售價: $1,730
  • 貴賓價: 9.5 折 $1,644
  • 語言: 英文
  • 頁數: 692
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484264819
  • ISBN-13: 9781484264812
  • 相關分類: .NET、MSSQL、SQL

    • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS task to the Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR).

All examples in this new edition are implemented in C#. Custom task developers are shown how to implement custom tasks using the widely accepted and default language for .NET development.

Why are custom components necessary? Because even though the SSIS catalog of built-in tasks and components is a marvel of engineering, gaps remain in the available functionality. One such gap is a constraint of the built-in SSIS Execute Package Task, which does not allow SSIS developers to select SSIS packages from other projects in the SSIS Catalog. Examples in this book show how to create a custom Execute Catalog Package task that allows SSIS developers to execute tasks from other projects in the SSIS Catalog. Building on the examples and patterns in this book, SSIS developers may create any task to which they aspire, custom tailored to their specific data integration and ETL needs.

 


What You Will Learn

 

  • Configure and execute Visual Studio in the way that best supports SSIS task development
  • Create a class library as the basis for an SSIS task, and reference the needed SSIS assemblies
  • Properly sign assemblies that you create in order to invoke them from your task
  • Implement source code control via Azure DevOps, or your own favorite tool set
  • Troubleshoot and execute custom tasks as part of your own projects
  • Create deployment projects (MSIs) for distributing code-complete tasks
  • Deploy custom tasks to Azure Data Factory Azure-SSIS IRs in the cloud
  • Create advanced editors for custom task parameters

 

Who This Book Is For
For database administrators and developers who are involved in ETL projects built around SQL Server Integration Services (SSIS). Readers do not need a background in software development with C#. Most important is a desire to optimize ETL efforts by creating custom-tailored tasks for execution in SSIS packages, on-premises or in ADF Azure-SSIS IRs.

商品描述(中文翻譯)

使用Visual Studio Community Edition和C#來建立自訂的SQL Server Integration Services (SSIS)任務。將Microsoft .NET的所有功能應用於您的數據集成和ETL流程，而且不需要額外花費，因為您已經在SQL Server的授權上花費了費用。本版本新增了一個示範，展示如何將自訂的SSIS任務部署到Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR)。

本書中的所有示例都是使用C#實現的。將向自訂任務開發人員展示如何使用廣泛接受且是.NET開發的默認語言。

為什麼需要自訂組件？因為即使SSIS內建的任務和組件庫是一個工程奇蹟，但仍然存在可用功能的缺口。其中一個缺口是內建的SSIS執行封裝任務的限制，它不允許SSIS開發人員從SSIS目錄中選擇其他專案中的SSIS封裝。本書中的示例展示了如何創建一個自訂的執行目錄封裝任務，使SSIS開發人員能夠從SSIS目錄中執行其他專案中的任務。在本書的示例和模式的基礎上，SSIS開發人員可以創建任何他們渴望的任務，以滿足其特定的數據集成和ETL需求。

您將學到什麼：

- 配置和執行最適合SSIS任務開發的Visual Studio
- 創建一個類庫作為SSIS任務的基礎，並引用所需的SSIS組件
- 正確簽署您創建的組件，以便從您的任務中調用它們
- 通過Azure DevOps或您喜歡的工具集實施源代碼控制
- 作為您自己專案的一部分，進行故障排除和執行自訂任務
- 創建用於分發完整代碼任務的部署專案（MSI）
- 將自訂任務部署到雲端中的Azure Data Factory Azure-SSIS IR
- 創建自訂任務參數的高級編輯器

本書適合對圍繞SQL Server Integration Services (SSIS)構建的ETL專案有興趣的數據庫管理員和開發人員。讀者不需要具備C#軟體開發背景，最重要的是希望通過創建針對SSIS封裝的自訂任務來優化ETL工作，無論是在本地還是在ADF Azure-SSIS IR中執行。

作者簡介

Andy Leonard is Chief Data Engineer at Enterprise Data & Analytics, an SSIS trainer, consultant, developer of the Data Integration Lifecycle Management (DILM) Suite, a Business Intelligence Markup Language (Biml) developer, and BimlHero. He is a SQL Server database and data warehouse developer, community mentor, engineer, and occasional farmer. He is co-author of Apress books SQL Server Integration Services Design Patterns and The Biml Book, and author of the Apress book Data Integration Life Cycle Management with SSIS and the Stairway to Integration Services series at SQLServerCentral.com.

作者簡介(中文翻譯)

Andy Leonard是Enterprise Data & Analytics的首席數據工程師，他是一位SSIS培訓師、顧問，也是Data Integration Lifecycle Management (DILM) Suite的開發者，同時也是一位Business Intelligence Markup Language (Biml)開發者和BimlHero。他是一位SQL Server數據庫和數據倉庫開發者，社區導師，工程師，偶爾也是農夫。他是Apress書籍《SQL Server Integration Services Design Patterns》和《The Biml Book》的合著者，也是Apress書籍《Data Integration Life Cycle Management with SSIS》和SQLServerCentral.com的Stairway to Integration Services系列的作者。

類似商品