Logo - springer
Slogan - springer

Computer Science | Pro SQL Server 2012 Integration Services

Pro SQL Server 2012 Integration Services

Rodrigues, Francis, Coles, Michael, Dye, David

2012, XVIII, 636 p.

A product of Apress
Available Formats:

Springer eBooks may be purchased by end-customers only and are sold without copy protection (DRM free). Instead, all eBooks include personalized watermarks. This means you can read the Springer eBooks across numerous devices such as Laptops, eReaders, and tablets.

You can pay for Springer eBooks with Visa, Mastercard, American Express or Paypal.

After the purchase you can directly download the eBook file or read it online in our Springer eBook Reader. Furthermore your eBook will be stored in your MySpringer account. So you can always re-download your eBooks.


(net) price for USA

ISBN 978-1-4302-3693-1

digitally watermarked, no DRM

Included Format: PDF

download immediately after purchase

learn more about Springer eBooks

add to marked items


Softcover (also known as softback) version.

You can pay for Springer Books with Visa, Mastercard, American Express or Paypal.

Standard shipping is free of charge for individual customers.


(net) price for USA

ISBN 978-1-4302-3692-4

free shipping for individuals worldwide

usually dispatched within 3 to 5 business days

add to marked items

    • Speaks to a growing market. ETL is a key enabler of business intelligence solutions. Much of what is new in SQL Server 2012 is built to support growing demand for such solutions.
    • Contains commentary by Andy Leonard, who was a key co-author of the most successful book ever on Integration Services.
    • Provides Microsoft MVP insider perspectives on developing ETL solutions on Microsoft's latest and greatest database platform.
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

Content Level » Popular/general

Related subjects » Computer Science

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


Popular Content within this publication 



Read this Book on Springerlink

Services for this book

New Book Alert

Get alerted on new Springer publications in the subject area of Computer Science (general).