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
