CHAPTER 3
XML Data Sources
It has become a truism, but XML is now the lingua franca of data exchange. Where, four or five years ago, delimited text files would have been the norm, XML files are now being used in their place. Certainly XML has its faults—and file size is not the least of them, especially when compared to text file source data. But for sheer reliability and ease of debugging XML-based data loads, I prefer to use XML files as source data over flat files any time.
So this chapter will lead you through the classic ways of getting XML data into SQL Server. However, before beginning, a few words of warning. XML is horrendously complex, ...
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.
