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
Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services
β Scribed by Joost van Rossum, RΓ©gis Baccaro (auth.)
- Publisher
- Apress
- Year
- 2015
- Tongue
- English
- Leaves
- 481
- Category
- Library
No coin nor oath required. For personal study only.
β¦ Table of Contents
Front Matter....Pages i-xxv
Front Matter....Pages 1-1
Getting Started with SSIS and Scripting....Pages 3-30
Script Task vs. Script Component....Pages 31-54
.NET Fundamentals....Pages 55-66
Front Matter....Pages 67-67
Script Task....Pages 69-114
File Properties....Pages 115-144
Working Through the Internet and the Web....Pages 145-174
Working with Web Services and XML....Pages 175-193
Advanced Solutions with Script Task....Pages 195-215
Front Matter....Pages 217-217
Script Component Foundation....Pages 219-241
Script Component As Source....Pages 243-265
Script Component Transformation....Pages 267-293
Script Component As Destination....Pages 295-310
Regular Expressions....Pages 311-326
Script Component Reflection....Pages 327-348
Web Services....Pages 349-381
Front Matter....Pages 383-383
Create a Custom Task....Pages 385-409
Create Custom Transformation....Pages 411-430
Front Matter....Pages 431-431
Package Creation....Pages 433-448
Package Execution from .NET....Pages 449-465
Back Matter....Pages 467-472
β¦ Subjects
Computer Science, general
π SIMILAR VOLUMES
<div><p>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
Microsoft is completely revamping its database product, SQL Server, and adding a host of new tools that will provide a powerful, full featured data warehouse toolset perfectly suited for smaller organizations. This book offers practical examples implemented on the Microsoft's Business Intelligence (