Building Custom Tasks for SQL Server Integration Services
Published on 4. July 2017
XVII, 111 pages
978-1-4842-2940-8 (ISBN)
Description
SQL Server Integration Services (SSIS) is widely used whenever data from outside sources is loaded into a SQL Server database. Extract, Transform, and Load (ETL) processes feeding data marts and business intelligence systems are two common scenarios in which SSIS is used, and it's often the case that SSIS's built-in feature set can be enhanced to make loads run faster, and to otherwise process data so as to save time and provide business benefit. This book shows how to create such enhancements by way of custom SSIS tasks built using a free toolset provided by Microsoft in the form of Visual Studio Community Edition and the Visual Basic language.
More details
Series
Edition
1st ed.
Language
English
Place of publication
Berkeley
United States
Publishing group
APRESS
Target group
Professional and scholarly
Product notice
Reflowable
Illustrations
XVII, 111 p. 146 illus., 125 illus. in color.
File size
7,94 MB
ISBN-13
978-1-4842-2940-8 (9781484229408)
DOI
10.1007/978-1-4842-2940-8
Schweitzer Classification
Other editions
New editions
Andy Leonard
Building Custom Tasks for SQL Server Integration Services
The Power of .NET for ETL for SQL Server 2019 and Beyond
E-Book
02/2021
2nd Edition
APress
€46.99
Available for download
Additional editions
Book
08/2017
Apress
€26.74
Article exhausted; check for reprint
Person
Andy Leonard
is a Data Philosopher at Enterprise Data & Analytics, an SSIS trainer, consultant, developer of the Data Integration Lifecycle Management (DILM) Suite, a Business Intelligence Markup Language (Biml) developer and BimlHero. He is also a SQL Server database and data warehouse developer, community mentor, engineer, and farmer. Andy is co-author of
SQL Server Integration Services Design Patterns
, and of
Stairway to
Integration Services
.
Content
1. Story of This Book.- 2. Creating the Assembly.- 3. Signing the Assembly.- 4. Preparing the Environment.- 5. Coding the Task.- 6. Coding the Task Editor.- 7. Signing and Binding.- 8. Tips on Troubleshooting.- 9. Notes from Experience.- 10. Demonstration Code.
