Apress Android Sale

Pro SQL Server 2012 Integration Services

By Francis Rodrigues , Michael Coles , David Dye

  • eBook Price: $34.99
  • Print Book Price: $49.99
Buy eBook Buy Print Book
Pro SQL Server 2012 Integration Services is your key to building powerful extract, transform, load (ETL) solutions using SQL Server 2012 Integration Services (SSIS).

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-3692-4
  • 636 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: June 26, 2012
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Pro SQL Server Wait Statistics
  • Pro PowerShell for Database Developers
  • SQL Server T-SQL Recipes
  • Extending SSIS with .NET Scripting
  • Healthy SQL
  • Expert T-SQL Window Functions in SQL Server
  • Pro T-SQL Programmer\'s Guide
Full Description

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

Who this book is for

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

Table of Contents

Table of Contents

  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

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published

Best-Sellers

    1. Pro SQL Server Internals

      $41.99

      View Details

    2. Beginning 3D Game Development with Unity 4

      $34.99

      View Details

    3. Beginning iPhone Development with Swift

      $31.99

      View Details

    4. Financial Modeling for Business Owners and Entrepreneurs

      $31.99

      View Details