Pro SQL Server 2012 Integration Services

Купить бумажную книгу и читать

Название: Pro SQL Server 2012 Integration Services

Автор: Francis Rodrigues, Michael Coles

Год: 2012

ISBN-10: 1430236922

Формат: PDF

Страниц: 636 pages

Размер: 24 MB

Издатель: Apress

Pro SQL Server 2012 Integration Services 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.

Whether 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.

Helps you design and develop robust, efficient, scalable ETL solutions

Walks you through using the built-in, stock components

Shows how to programmatically extend the power of SSIS to cover any possible scenario

What you’ll learn

Create an SSIS package from scratch

Deploy an SSIS package to any environment

Benchmark the performance of SSIS packages using common tools

Optimize SSIS data flows to achieve maximum performance

Use .NET to extend the power of the stock SSIS toolkit

Profile and scrub data during the ETL process