Pro SQL Server 2012 Integration Services, 1st ed.

Authors:

Language: English
Cover of the book Pro SQL Server 2012 Integration Services

Subjects for Pro SQL Server 2012 Integration Services

Approximative price 52.74 €

In Print (Delivery period: 15 days).

Add to cartAdd to cart
Publication date:
636 p. · 17.8x25.4 cm · Paperback
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

 

  1. Introducing Integration Services 
  2. BIDS and SSMS 
  3. “Hello World!”—Your First SSIS 2012 Package 
  4. Connection Managers 
  5. Control Flow Basics 
  6. Advanced Control Flow Tasks 
  7. Source and Destination Adapters 
  8. Data Flow Transformations 
  9. Variables, Parameters, and Expressions 
  10. Scripting 
  11. Events and Error Handling 
  12. Data Profiling and Scrubbing 
  13. Logging, Auditing and Data Lineage
  14. Heterogeneous Sources and Destinations 
  15. Data Flow Tuning and Optimization 
  16. Parent-Child Design Pattern 
  17. Dimensional Data ETL 
  18. Building Robust Solutions 
  19. Deployment Model

 

Francis Rodrigues is a business intelligence consultant based out of New York City. A computer science graduate of Loyola College in Maryland, he is an expert developer of enterprise business intelligence projects. His specialties include extract, transfer, load (ETL) solutions based on SQL Server, SQL Server Integration Services (SSIS), and Oracle.

Pro SQL Server 2012 Integration Services is your key to building powerful extract, transform, load (ETL) solutions using SQL Server 2012 Integration Services (SSIS).