Introduction

Microsoft SQL Server 2012 is a vast subject. One part of the ecosystem of this powerful and comprehensive database which has evolved considerably over many years is data integration – or ETL if you want to use another virtually synonymous term. Long gone are the days when BCP was the only available tool to load or export data. Even DTS is now a distant memory. Today the user is spoilt for choice when it comes to the plethora of tools and options available to get data into and out of the Microsoft RDBMS. This book is an attempt to shed some light on many of the ways in which data can be both loaded into SQL Server and sent from it into the outside world. I also try to give some ideas as to which techniques are the most appropriate ...

Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.