Extending SSIS with .NET Scripting

A Toolkit for SQL Server Integration Services

Authors: van Rossum, Joost, Baccaro, Regis

Download source code
  • Scripting SSIS with .Net is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter.

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4842-0638-6
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $49.99
price for USA
  • ISBN 978-1-4842-0639-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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

    About the authors

    <p><strong>Joost van Rossum</strong> is a Data Warehouse / Business Intelligence consultant for 10 years with a focus on the Microsoft SQL Server stack, and especially on SQL Server Integration Services. He speaks and blogs (http://microsoft-ssis.blogspot.com) about SSIS, and he answers and moderates questions in the Integration Services Forum on MSDN. This gives him a lot of knowledge about the problems that SSIS developers encounter during their daily work.</p><p>Before his DWH / BI career, van Rossum worked as a developer with JavaScript, VBA, ASP, ASP.Net, C# and VB.NET, and tools like Microsoft Content Management Server and Microsoft SharePoint Portal Server. With this knowledge he knows well how to apply .NET to scripting solutions in SSIS.<br /></p>

    Table of contents (19 chapters)

    Buy this book

    eBook $39.99
    price for USA
    • ISBN 978-1-4842-0638-6
    • Digitally watermarked, DRM-free
    • Included format: PDF, EPUB
    • ebooks can be used on all reading devices
    • Immediate eBook download after purchase
    Softcover $49.99
    price for USA
    • ISBN 978-1-4842-0639-3
    • Free shipping for individuals worldwide
    • Usually dispatched within 3 to 5 business days.

    Services for this book

    Loading...

    Bibliographic Information

    Bibliographic Information
    Book Title
    Extending SSIS with .NET Scripting
    Book Subtitle
    A Toolkit for SQL Server Integration Services
    Authors
    Copyright
    2015
    Publisher
    Apress
    Copyright Holder
    Joost van Rossum and Regis Baccaro
    eBook ISBN
    978-1-4842-0638-6
    DOI
    10.1007/978-1-4842-0638-6
    Softcover ISBN
    978-1-4842-0639-3
    Edition Number
    1
    Number of Pages
    XXV, 472
    Number of Illustrations and Tables
    271 b/w illustrations
    Topics