{"product_id":"9781484206386","title":"Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services","description":"\u003cp\u003e\u003cem\u003e\u003c\/em\u003e\u003cem\u003eExtending SSIS with .NET Scripting\u003c\/em\u003e 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. \u003c\/p\u003e\u003cp\u003eSSIS 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. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eProvides a timeless scripting toolkit for all current SSIS versions\u003c\/li\u003e\n\u003cli\u003eGives a comprehensive explanation of scripting in SSIS\u003c\/li\u003e\n\u003cli\u003eOffers a wide array of readymade examples for everyday problems\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e\n\u003cli\u003eBuild solutions around the Script Task and Script Component\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003eApply readymade scripting examples from the book to your own projects\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003eCreate own scripting solutions that are written in Microsoft .NET\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003eImplement custom tasks, enumerators, connection managers, and transformations\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003eAutomate execution of SSIS packages through scripting\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003eUnderstand tradeoffs to properly apply different customization options\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eWho this book is for      \u003c\/p\u003e\u003cp\u003e     \u003cem\u003eScripting SSIS with .NET\u003c\/em\u003e 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.       \u003c\/p\u003e     Table of Contents\u003cp\u003eIntroduction\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart I: Getting Started\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eChapter 1: Getting Started with SSIS and Scripting\u003c\/p\u003e\u003cp\u003eChapter 2: Script Tasks vs Script Components\u003c\/p\u003e\u003cp\u003eChapter 3: .NET Fundamentals\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart II: Script Tasks\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eChapter 4: Script Task Foundations\u003c\/p\u003e\u003cp\u003eChapter 5: File Properties\u003c\/p\u003e\u003cp\u003eChapter 6: Working Through Internet And Web\u003c\/p\u003e\u003cp\u003eChapter 7: Working with Web Services and XML\u003c\/p\u003e\u003cp\u003eChapter 8:Advanced Solutions with Script Task\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart III: Script Component\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eChapter 9: Script Component Foundations\u003c\/p\u003e\u003cp\u003eChapter 10: Script Components as a Source\u003c\/p\u003e\u003cp\u003eChapter 11: Script Components as a Transformation\u003c\/p\u003e\u003cp\u003eChapter 12: Script Components as a Destination\u003c\/p\u003e\u003cp\u003eChapter 13: Regular Expressions\u003c\/p\u003e\u003cp\u003eChapter 14: Reflection\u003c\/p\u003e\u003cp\u003eChapter 15: Web Services\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart IV: Custom Tasks and Components\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eChapter 16: Create Custom Tasks\u003c\/p\u003e\u003cp\u003eChapter 17: Create Custom Data Flow Components\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart V: Scripting from .NET Applications\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eChapter 18: Package Creation\u003c\/p\u003e\u003cp\u003eChapter 19: Execution and Deployment\u003c\/p\u003e\u003cp\u003eChapter 20: Best Practices\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47165204431088,"sku":"9781484206386","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781484206386_p0.jpg?v=1763632038","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781484206386","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}