Extending SSIS with .NET Scripting (eBook)
XXV, 472 Seiten
Apress (Verlag)
978-1-4842-0638-6 (ISBN)
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
<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>
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 versionsGives a comprehensive explanation of scripting in SSISOffers a wide array of readymade examples for everyday problems
Joost van Rossum 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.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.
IntroductionPart I: Getting StartedChapter 1: Getting Started with SSIS and ScriptingChapter 2: Script Tasks vs Script ComponentsChapter 3: .NET FundamentalsPart II: Script TasksChapter 4: Script Task FoundationsChapter 5: File PropertiesChapter 6: Working Through Internet And WebChapter 7: Working with Web Services and XMLChapter 8: Common Real-World Scenarios with Script TasksPart III: Script ComponentChapter 9: Script Component FoundationsChapter 10: Script Components as a SourceChapter 11: Script Components as a TransformationChapter 12: Script Components as a DestinationChapter 13: Regular ExpressionsChapter 14: ReflectionChapter 15: Web ServicesPart IV: Custom Tasks and ComponentsChapter 16: Create Custom TasksChapter 17: Create Custom EnumeratorsChapter 18: Create Custom Connection ManagersChapter 19: Create Custom Data Flow ComponentsPart V: Scripting from .NET ApplicationsChapter 20: Package CreationChapter 21: Execution and DeploymentChapter 22: Best Practices
| Erscheint lt. Verlag | 19.10.2015 |
|---|---|
| Zusatzinfo | XXV, 472 p. 271 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 1-4842-0638-X / 148420638X |
| ISBN-13 | 978-1-4842-0638-6 / 9781484206386 |
| Informationen gemäß Produktsicherheitsverordnung (GPSR) | |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
