Abstract
A common way to transfer data between systems is to export the source data to a flat file and then import the contents of this file into the destination database. Flat files come in all shapes, sizes, and types. There are no rowlength limitations. File size is limited by the maximum size allowed by the operating system. When examining flat file types, there are two initial considerations: file format and schema. Common file formats of flat file sources include:
-
Comma-Separated Values (CSV)
-
Tab-Delimited File (TDF)
-
Fixed Width
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
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). Flat File Source Patterns. In: SQL Server 2012 Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3772-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3772-3_7
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