SQL Server 2012 Data Integration Recipes Solutions for Integration Services and Other ETL Tools

Name: SQL Server 2012 Data Integration Recipes Solutions for Integration Services and Other ETL Tools
Price: 11.99 USD
Availability: InStock
ISBN: 9781430247913

ISBN-10: 1430247916

ISBN-13: 9781430247913

Edition: 2012

Authors: Adam Aspin

List price: $79.99

This item qualifies for FREE shipping.

30 day, 100% satisfaction guarantee!

Buy new: $72.19

Marketplace

3 new & used from $11.99

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

SQL Server Data Integration Recipesprovides 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 Data Integration Recipeshas 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 Data Integration Recipesis the one book that will meet your needs.Provides practical and proven solutions towards creating resilient ETL environmentsClearly answers the tough questions which professionals askGoes beyond the tools to a thorough discussion of the underlying techniquesCovers the gamut of data integration, beyond just SSISIncludes example databases and files to allow readers to test the recipesWhat you’ll learnImport 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 forSQL Server Data Integration Recipesis 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.

Book details

List price: $79.99
Copyright year: 2012
Publisher: Apress L. P.
Publication date: 11/20/2012
Binding: Paperback
Pages: 1056
Size: 7.50" wide x 9.25" long x 2.07" tall
Weight: 4.290
Language: English

Adam Aspin is an ETL expert having 17 years experience with SQL Server and satallite products such as Data Transformation Services and SQL Server Integration Services. For the past decade he has focused especially on ETL projects. He has worked for high-profile clients such as J.P. Morgan, Marks and Spencer, Harrods, Tesco, and more. He has been a frequent contributor to SQLServerCentral.com, and has broad experience across a number of database platforms such as SQL Server, Oracle Database, MySQL, DB2, and others. Adam holds an MA from Oxford University.