Book description
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.
Table of contents
- Cover
- Title
- Copyright
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
-
Part I: Getting Started
- Chapter 1: Getting Started with SSIS and Scripting
- Chapter 2: Script Task vs. Script Component
- Chapter 3: .NET Fundamentals
-
Part II: Script Tasks
- Chapter 4: Script Task
- Chapter 5: File Properties
- Chapter 6: Working Through the Internet and the Web
- Chapter 7: Working with Web Services and XML
- Chapter 8: Advanced Solutions with Script Task
-
Part III: Script Component
- Chapter 9: Script Component Foundation
- Chapter 10: Script Component As Source
- Chapter 11: Script Component Transformation
- Chapter 12: Script Component As Destination
- Chapter 13: Regular Expressions
- Chapter 14: Script Component Reflection
- Chapter 15: Web Services
- Part IV: Custom Tasks and Components
- Part V: Scripting from .NET Applications
- Index
Product information
- Title: Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services
- Author(s):
- Release date: October 2015
- Publisher(s): Apress
- ISBN: 9781484206386
You might also like
book
SQL Server Integration Services Design Patterns, Second Edition
SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book …
book
Pro PowerShell for Database Developers
helps you master PowerShell application development by continuing where other books leave off. There are no …
book
Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring …
book
SQL Server 2017 Integration Services Cookbook
Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with …