Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services (Paperback)

Joost van Rossum

  • 出版商: Apress
  • 出版日期: 2015-10-07
  • 售價: $3,240
  • 貴賓價: 9.5$3,078
  • 語言: 英文
  • 頁數: 500
  • 裝訂: Paperback
  • ISBN: 1484206398
  • ISBN-13: 9781484206393
  • 相關分類: .NETMSSQLSQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS.

SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed.

  • Provides a timeless scripting toolkit for all current SSIS versions
  • Gives a comprehensive explanation of scripting in SSIS
  • Offers a wide array of readymade examples for everyday problems

    What you’ll learn

    • Build solutions around the Script Task and Script Component

    • Apply readymade scripting examples from the book to your own projects

    • Create own scripting solutions that are written in Microsoft .NET

    • Implement custom tasks, enumerators, connection managers, and transformations

    • Automate execution of SSIS packages through scripting

    • Understand tradeoffs to properly apply different customization options

    Who this book is for

    Scripting SSIS with .NET is aimed at developers with at least some experience in creating SSIS packages. It is especially targeted at those who have encountered limitations using out-of-the-box tasks and transformations. A secondary audience are those with .NET programming experience who are now heavily involved in database, and especially in ETL work.

    Table of Contents

    Introduction

    Part I: Getting Started

    Chapter 1: Getting Started with SSIS and Scripting

    Chapter 2: Script Tasks vs Script Components

    Chapter 3: .NET Fundamentals

    Part II: Script Tasks

    Chapter 4: Script Task Foundations

    Chapter 5: File Properties

    Chapter 6: Working Through Internet And Web

    Chapter 7: Working with Web Services and XML

    Chapter 8:Advanced Solutions with Script Task

    Part III: Script Component

    Chapter 9: Script Component Foundations

    Chapter 10: Script Components as a Source

    Chapter 11: Script Components as a Transformation

    Chapter 12: Script Components as a Destination

    Chapter 13: Regular Expressions

    Chapter 14: Reflection

    Chapter 15: Web Services

    Part IV: Custom Tasks and Components

    Chapter 16: Create Custom Tasks

    Chapter 17: Create Custom Data Flow Components

    Part V: Scripting from .NET Applications

    Chapter 18: Package Creation

    Chapter 19: Execution and Deployment

    Chapter 20: Best Practices

    商品描述(中文翻譯)

    《使用.NET腳本擴展SSIS》是一本全面且具有永久價值的腳本工具包,專為SQL Server Integration Services(SSIS)開發人員解決各種日常問題而設計。詳細解釋了腳本任務和腳本組件的基礎知識,幫助您開發自己的腳本解決方案,同時還展示了一系列常見問題的現成且有文檔記錄的腳本解決方案。所有示例均使用C#和VB.NET編寫,並適用於所有當前版本的SSIS。

    SSIS是當今市場上領先的ETL、數據合併和數據轉換工具之一。ETL開發人員、數據庫管理員和數據分析師使用SSIS根據不同的ETL流程對數據進行轉換。SSIS提供了許多內置組件和任務,以幫助開發人員執行操作。例如,有用於通過FTP發送和接收文件、發送電子郵件以及訪問各種數據庫管理系統的任務。然而,有時開發人員需要一個不存在的任務或組件,如果能夠創建該任務或組件,將使他們的工作更加輕鬆,這正是本書的主題。本書展示了如何編寫.NET腳本並使用強大的Microsoft .NET庫來實現所需的新功能。

    本書的特點包括:
    - 提供了適用於所有當前SSIS版本的永久腳本工具包
    - 全面解釋了SSIS中的腳本編寫
    - 提供了各種現成的示例,解決日常問題

    本書適合具有一定SSIS包開發經驗的開發人員,特別是那些在使用內置任務和轉換時遇到限制的人。其次,本書還適合具有.NET編程經驗並且現在在數據庫,尤其是ETL工作中積極參與的人。

    目錄:
    - 引言
    - 第一部分:入門
    - 第二部分:腳本任務
    - 第三部分:腳本組件
    - 第四部分:自定義任務和組件
    - 第五部分:從.NET應用程序進行腳本編寫

    這本書將教會您:
    - 圍繞腳本任務和腳本組件構建解決方案
    - 將書中的現成腳本示例應用於您自己的項目
    - 創建使用Microsoft .NET編寫的自定義腳本解決方案
    - 實現自定義任務、枚舉器、連接管理器和轉換
    - 通過腳本編寫自動執行SSIS包
    - 理解不同自定義選項的權衡