{"product_id":"9781430236931","title":"Pro SQL Server 2012 Integration Services","description":"\u003cp\u003e    \u003cem\u003ePro SQL Server 2012 Integration Services\u003c\/em\u003e teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source. \u003c\/p\u003e\u003cp\u003eWhether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eHelps you design and develop robust, efficient, scalable ETL solutions \u003c\/li\u003e\n\u003cli\u003eWalks you through using the built-in, stock components \u003c\/li\u003e\n\u003cli\u003eShows how to programmatically extend the power of SSIS to cover any possible scenario \u003c\/li\u003e\n\u003c\/ul\u003e         What you’ll learn\u003cul\u003e \u003cli\u003eCreate an SSIS package from scratch \u003c\/li\u003e \u003cli\u003eDeploy an SSIS package to any environment \u003c\/li\u003e \u003cli\u003eBenchmark the performance of SSIS packages using common tools \u003c\/li\u003e \u003cli\u003eOptimize SSIS data flows to achieve maximum performance \u003c\/li\u003e \u003cli\u003eUse .NET to extend the power of the stock SSIS toolkit \u003c\/li\u003e \u003cli\u003eProfile and scrub data during the ETL process \u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003ePro SQL Server 2012 Integration Services\u003c\/em\u003e is for ETL developers, SQL developers, and database administrators at all levels of experience who want to harness the power of SSIS on SQL Server 2012. Whether you are using SSIS to build small, one-off ETL packages in a small shop, or building enterprise-wide ETL solutions in a Fortune 500 company, this book gives you the information you'll need to build powerful, scalable, and efficient ETL solutions at any level of complexity.      \u003c\/p\u003e     Table of Contents\u003cp\u003e \u003c\/p\u003e\u003col\u003e \u003cli\u003eIntroducing Integration Services  \u003c\/li\u003e \u003cli\u003eBIDS and SSMS  \u003c\/li\u003e \u003cli\u003e“Hello World!”—Your First SSIS 2012 Package  \u003c\/li\u003e \u003cli\u003eConnection Managers  \u003c\/li\u003e \u003cli\u003eControl Flow Basics  \u003c\/li\u003e \u003cli\u003eAdvanced Control Flow Tasks  \u003c\/li\u003e \u003cli\u003eSource and Destination Adapters  \u003c\/li\u003e \u003cli\u003eData Flow Transformations  \u003c\/li\u003e \u003cli\u003eVariables, Parameters, and Expressions  \u003c\/li\u003e \u003cli\u003eScripting  \u003c\/li\u003e \u003cli\u003eEvents and Error Handling  \u003c\/li\u003e \u003cli\u003eData Profiling and Scrubbing  \u003c\/li\u003e \u003cli\u003eLogging, Auditing and Data Lineage \u003c\/li\u003e \u003cli\u003eHeterogeneous Sources and Destinations  \u003c\/li\u003e \u003cli\u003eData Flow Tuning and Optimization  \u003c\/li\u003e \u003cli\u003eParent-Child Design Pattern  \u003c\/li\u003e \u003cli\u003eDimensional Data ETL  \u003c\/li\u003e \u003cli\u003eBuilding Robust Solutions  \u003c\/li\u003e \u003cli\u003eDeployment Model \u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e \u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47141783732464,"sku":"9781430236931","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430236931_p0.jpg?v=1763750297","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430236931","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}