Flat File Source Patterns

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 row-length 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

In a flat file, as in a database, schema includes columns and data types. Schema ...

Get SQL Server 2012 Integration Services Design Patterns 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.