Extending SSIS with .NET Scripting

Synopsis

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

Copyright:

2015

Book Details

Book Quality:

Publisher Quality

ISBN-13:

9781484206386

Publisher:

Apress, Berkeley, CA

Date of Addition:

11/30/16

Copyrighted By:

Springer

Adult content:

No

Language:

English

Has Image Descriptions:

No

Categories:

Nonfiction, Computers and Internet

Submitted By:

Bookshare Staff

Usage Restrictions:

This is a copyrighted book.