相關主題
商品描述
Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. 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. If you already have a license for SQL Server, then you do not need to spend more money to extend SSIS with custom tasks and components.
Why are custom components necessary? Because even though the SSIS catalog of built-in tasks and components is a marvel of engineering, there do remain gaps in the functionality that is provided. These gaps are especially relevant to enterprises practicing Data Integration Lifecycle Management (DILMS) and/or DevOps.
One of the gaps is a limitation of the SSIS Execute Package task. Developers using the stock version of that task are unable to select SSIS packages from other projects. Yet it’s useful to be able to select and execute tasks across projects, and the example used throughout this book will help you to create an Execute Catalog Package task that does in fact allow you to execute a task from another project. Building on the example’s pattern, you can create any task that you like, custom tailored to your 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 Visual Studio Team Services, or your own favorite tool set
- Code not only your tasks themselves, but also the associated task editors
- Troubleshoot and then execute your custom tasks as part of your own project
Who This Book Is For
商品描述(中文翻譯)
學習使用Visual Studio Community Edition和Visual Basic來建立自定義的SSIS任務。將Microsoft .NET的所有功能應用於您的數據集成和ETL流程，而且不需要額外花費，因為您已經在SQL Server的授權上花費了費用。如果您已經有SQL Server的授權，那麼您無需花費更多金錢來擴展SSIS的自定義任務和組件。
為什麼需要自定義組件？因為儘管SSIS內置的任務和組件庫是一個工程奇蹟，但仍然存在功能上的缺陷。這些缺陷對於實踐數據集成生命周期管理（DILMS）和/或DevOps的企業尤其重要。
其中一個缺陷是SSIS執行包任務的限制。使用該任務的原始版本的開發人員無法從其他項目中選擇SSIS包。然而，能夠選擇並執行跨項目的任務非常有用，本書中的示例將幫助您創建一個執行目錄包任務，實際上允許您從另一個項目中執行任務。根據示例的模式，您可以創建任何您喜歡的任務，根據您特定的數據集成和ETL需求進行定制。
您將學到什麼：
- 配置和執行最適合SSIS任務開發的Visual Studio
- 創建一個類庫作為SSIS任務的基礎，並引用所需的SSIS組件
- 正確簽署您創建的組件，以便從您的任務中調用它們
- 通過Visual Studio Team Services或您喜歡的工具集實施源代碼控制
- 不僅編寫任務本身，還編寫相關的任務編輯器
- 作為您自己項目的一部分，排除故障並執行您的自定義任務
本書適合對SQL Server Integration Services（SSIS）構建的ETL項目有興趣的數據庫管理員和開發人員。讀者應該具備編程背景，並希望通過創建定制的任務來優化他們的ETL工作。
