SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools
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.
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.
What people are saying - Write a review
Chapter 2 Flat File Data Sources
Chapter 3 XML Data Sources
Chapter 4 SQL Databases
Chapter 5 SQL Server Sources
Chapter 6 Miscellaneous Data Sources
Chapter 7 Exporting Data from SQL Server
Chapter 8 Metadata
Chapter 9 Data Transformation
Chapter 10 Data Profiling
Chapter 11 Delta Data Management
Chapter 12 Change Tracking and Change Data Capture
About the Technical Reviewers