Advertisement

Flat File Source Patterns

  • Andy Leonard
  • Matt Masson
  • Tim Mitchell
  • Jessica M. Moss
  • Michelle Ufford

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

Keywords

Data Flow Package Parameter Flat File Connection Manager Derive Column 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford 2012

Authors and Affiliations

  • Andy Leonard
  • Matt Masson
  • Tim Mitchell
  • Jessica M. Moss
  • Michelle Ufford

There are no affiliations available

Personalised recommendations