Abstract
XML is a popular format for exchanging data between systems. SSIS provides an XML Source adapter, but because of the flexible nature of XML, it can sometimes be tricky to get your data to fit into the tabular format that the SSIS data flow expects. This chapter describes the formats that work best with the XML Source and two alternative patterns for reading XML data with SSIS.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford
About this chapter
Cite this chapter
Leonard, A., Masson, M., Mitchell, T., Moss, J.M., Ufford, M. (2012). XML Patterns. In: SQL Server 2012 Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3772-3_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3772-3_9
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3771-6
Online ISBN: 978-1-4302-3772-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books