Extract, Transform, and Load with SQL Server Integration Services

Today's business applications draw data from diverse sources' from Microsoft Excel spreadsheets to enterprise databases like DB2, SQL Server, and Oracle. How can developers and DBAs easily pull that data into their apps, no matter where the data resides? You'll find the solution in this book: a straightforward method that uses Microsoft's SQL Server Integration Services (SSIS) to retrieve data using an extract, transform, and load (ETL) process.

In Extract, Transform, and Load with SQL Server Integration Services, authors Thomas Snyder and Vedish Shah explain step by step how to install and use SSIS 2016 with a few other common tools to build packages that let applications access data in any database platform across the enterprise.

Readers will learn by example as they build an ETL solution that integrates with a data warehouse and an online Web store across a heterogeneous system. The book draws on the authors' extensive experience developing and running the ETL solution in actual business environments and on production systems. You'll learn how to enable databases to communicate directly with each other, use files to exchange data, and perform database operations using Web services. You'll also get downloadable database files and code you can use to implement the ETL solution in your environment.

After you've read this book, you will know how to:

• Use industry-standard software tools to build ETL solutions for business applications.
• Apply ETL solutions across a variety of databases.
• Import and export database content to/from files in multiple formats, such as Excel, CSV, and XML.
• Create modular, reusable SSIS parts and scripts.
• Implement exception handling with logging and notifications.
• Provide common data exchanges across the network with SSIS using Web services.

Book illustrations by Traci Phillips Healey.