Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert's Voice in SQL Server)


SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.

  • Provides practical and proven solutions towards creating resilient ETL environments
  • Clearly answers the tough questions which professionals ask
  • Goes beyond the tools to a thorough discussion of the underlying techniques
  • Covers the gamut of data integration, beyond just SSIS
  • Includes example databases and files to allow readers to test the recipes

What you’ll learn

  • Import and export to and from CSV files, XML files, and other text-based sources.
  • Move data between SQL databases, including SQL Server and others such as Oracle Database and MySQL.
  • Discover and manage metadata held in various database systems.
  • Remove duplicates and consolidate from multiple sources.
  • Transform data to meet the needs of target systems.
  • Profile source data as part of the discovery process.
  • Log and manage errors and exceptions during an ETL process.
  • Improve efficiency by detecting and processing only changed data.

Who this book is for

SQL Server 2012 Data Integration Recipes is written for developers wishing to find fast and reliable solutions for importing and exporting to and from SQL Server. The book appeals to DBAs as well, who are often tasked with implementing ETL processes. Developers and DBAs moving to SQL Server from other platforms will find the succinct, example-based approach ideal for quickly applying their general ETL knowledge to the specific tools provided as part of a SQL Server environment.

Table of Contents

  1. MS Office Data Sources
  2. Flat File Sources
  3. XML Data Sources
  4. SQL Database Sources
  5. SQL Server Sources
  6. Miscellaneous Data Sources
  7. Exporting Data from SQL Server
  8. Metadata
  9. Data Transformation
  10. Data Profiling
  11. Delta Data Management
  12. Change Tracking and Change Data Capture 
  13. Optimising Data Import
  14. ET Process Acceleration
  15. Logging and Auditing
  16. Appendix A: Data Types
  17. Appendix B: Sample Databases and Scripts
(HTML tags aren't allowed.)

Pro SQL Server 2012 Integration Services (Professional Apress)
Pro SQL Server 2012 Integration Services (Professional 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...

Pro SQL Server 2012 BI Solutions (Professional Apress)
Pro SQL Server 2012 BI Solutions (Professional Apress)

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete! Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business...

SQL Server Analysis Services 2012 Cube Development Cookbook
SQL Server Analysis Services 2012 Cube Development Cookbook

If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast.


  • Develop Business Intelligence solutions using a multi-dimensional model...

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)
Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Fill the gap between planning and doing with SSIS 2014

The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased...

Murach's Java Programming
Murach's Java Programming

There is a Fifth Edition of this book

Developers often tell me they wish they'd found our Java book first, before spending time and money on others. They also say it's the book they turn to when they're getting ready to learn Android programming. Here are a few of the reasons why I believe this book...

Inside Internet Security: What Hackers Don't Want You To Know
Inside Internet Security: What Hackers Don't Want You To Know
This book is a practical guide for anyone designing or administering a corporate or e-business network that runs across a number of platforms via the Internet. It will arm systems administrators with a thorough understanding of the problems of network security and their solutions, and thus help realize the tremendous potential of e-business....
©2019 LearnIT (support@pdfchm.net) - Privacy Policy