locked
Flat file Destination VS Raw file Destination ?? RRS feed

  • Question

  • Team ,

    Can some help me understand few differences and similarities  between Flat File Destination and Raw File Destination ? Thanks in advance .


    Rajkumar Yelugu

    Saturday, December 28, 2013 8:16 AM

Answers

  • Hi,

    Please check these differences :-

    Flat File Destination: The Flat File Destination component writes data out to a text file in one of the standard flat-file formats: delimited, fixed width, fixed width with row delimiter.

    Raw File Destination: The Raw File Destination is all about raw speed. It is an entirely native format and can be exported and imported more rapidly than any other connection type, in part because the data doesn’t need to pass through a connection manager.


    durgesh sharma

    • Proposed as answer by Mike Yin Wednesday, January 1, 2014 12:35 PM
    • Marked as answer by Mike Yin Sunday, January 5, 2014 3:34 PM
    Saturday, December 28, 2013 10:08 AM
  • Raw files are a binary format that contain rowset data and metadata describing the column data types and sizes. The data in a raw file can be directly consumed by an OLE DB destination and can be used as a data source without having to do any mapping. Flat files are files containing character data with no metadata or mapping information.
    • Proposed as answer by Mike Yin Wednesday, January 1, 2014 12:35 PM
    • Marked as answer by Mike Yin Sunday, January 5, 2014 3:34 PM
    Saturday, December 28, 2013 3:02 PM

All replies

  • Hi,

    Please check these differences :-

    Flat File Destination: The Flat File Destination component writes data out to a text file in one of the standard flat-file formats: delimited, fixed width, fixed width with row delimiter.

    Raw File Destination: The Raw File Destination is all about raw speed. It is an entirely native format and can be exported and imported more rapidly than any other connection type, in part because the data doesn’t need to pass through a connection manager.


    durgesh sharma

    • Proposed as answer by Mike Yin Wednesday, January 1, 2014 12:35 PM
    • Marked as answer by Mike Yin Sunday, January 5, 2014 3:34 PM
    Saturday, December 28, 2013 10:08 AM
  • Raw files are a binary format that contain rowset data and metadata describing the column data types and sizes. The data in a raw file can be directly consumed by an OLE DB destination and can be used as a data source without having to do any mapping. Flat files are files containing character data with no metadata or mapping information.
    • Proposed as answer by Mike Yin Wednesday, January 1, 2014 12:35 PM
    • Marked as answer by Mike Yin Sunday, January 5, 2014 3:34 PM
    Saturday, December 28, 2013 3:02 PM
  • Thanks , Any more pointers to add in to this thread ?

    Rajkumar Yelugu

    Thursday, January 2, 2014 6:24 AM
  • Good question and good answer!  Thank you for the post.
    Tuesday, September 1, 2015 2:18 PM