{"product_id":"9781430237723","title":"SQL Server 2012 Integration Services Design Patterns","description":"\u003cp\u003e    \u003cem\u003eSQL Server 2012 Integration Services Design Patterns\u003c\/em\u003e is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In \u003cem\u003eSSIS Design Patterns\u003c\/em\u003e, we take you through several of these snippets in detail, providing the technical details of the resolution.\u003c\/p\u003e\u003cp\u003e\u003cem\u003eSQL Server 2012 Integration Services Design Patterns\u003c\/em\u003e does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, \u003cem\u003eSQL Server 2012 Integration Services Design Patterns\u003c\/em\u003e provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e \u003cli\u003eTakes you through solutions to several common data integration challenges \u003c\/li\u003e \u003cli\u003eDemonstrates new features in SQL Server 2012 Integration Services \u003c\/li\u003e \u003cli\u003eTeaches SSIS using practical examples \u003c\/li\u003e\n\u003c\/ul\u003e         What you’ll learn\u003cul\u003e \u003cli\u003eLoad data from flat file formats \u003c\/li\u003e \u003cli\u003eExplore patterns for executing SSIS packages \u003c\/li\u003e \u003cli\u003eDiscover a pattern for loading XML data \u003c\/li\u003e \u003cli\u003eMigrate SSIS packages through your application lifecycle without editing connections \u003c\/li\u003e \u003cli\u003eTake advantage of SSIS 2012 Dependency Services \u003c\/li\u003e \u003cli\u003eBuild an SSIS Framework to support your application needs \u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003eSQL Server 2012 Integration Services Design Patterns\u003c\/em\u003e is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It’s for the developer interested in locating a previously-tested solution quickly. \u003cem\u003eSQL Server 2012 Integration Services Design Patterns\u003c\/em\u003e is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It’s an excellent choice for business intelligence and data warehouse developers.      \u003c\/p\u003e     Table of Contents\u003col\u003e\n\u003cli\u003eMetadata Collection \u003c\/li\u003e\n\u003cli\u003eExecution Operations \u003c\/li\u003e\n\u003cli\u003eScripting \u003c\/li\u003e\n\u003cli\u003eSQL Server Source Patterns \u003c\/li\u003e\n\u003cli\u003eData Cleansing \u003c\/li\u003e\n\u003cli\u003eDB2 Source \u003c\/li\u003e\n\u003cli\u003eFlat File Source Patterns \u003c\/li\u003e\n\u003cli\u003eParallel Data Warehouse \u003c\/li\u003e\n\u003cli\u003eXML \u003c\/li\u003e\n\u003cli\u003eExpression Language Patterns \u003c\/li\u003e\n\u003cli\u003eData Warehouse \u003c\/li\u003e\n\u003cli\u003eLogging \u003c\/li\u003e\n\u003cli\u003eSlowly Changing Dimensions \u003c\/li\u003e\n\u003cli\u003eLoading the Cloud \u003c\/li\u003e\n\u003cli\u003eReporting \u003c\/li\u003e\n\u003cli\u003eParent-Child Patterns \u003c\/li\u003e\n\u003cli\u003eBIML \u003c\/li\u003e\n\u003cli\u003eConfiguration \u003c\/li\u003e\n\u003cli\u003eDeployment \u003c\/li\u003e\n\u003cli\u003eEstimating ETL Projects\u003c\/li\u003e\n\u003cli\u003eAppendix\u003c\/li\u003e\n\u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47124592099568,"sku":"9781430237723","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430237723_p0.jpg?v=1763749302","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430237723","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}