Extract, Transform, and Load with SQL Server Integration Services

Product Description Look Inside the Book Author Bio Specifications 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' e