Post reply

Flat File Connection Manager Header Row Delimiter

  • August 25, 2010 at 12:34 pm

    #141698

    I've searched all over and I can't seem to find the explanation for this field (on the Flat File Connection Manager Editor). Is the value for this:

    A. The delimiter used to parse the header row, or

    B. The delimiter used to set apart the header row from the rest of the file.

    To illustrate, if I have a simple csv file:

    FirstName,LastName,Age,BirthDate

    John,Henry,42,11/13/1969

    Sean,Connery,80,8/25/1930

    Should the "Header Row Delimiter" be set to Comma (interpretation "A"), or CRLF (interpretation "B").

    So far simple testing for writing to and reading from a file through connection managers set either way yield the same results, but I would still like a clarification. And if anyone also knows what "gotcha"s there are please let me know.

    Thanks!

  • August 25, 2010 at 2:01 pm

    #1211903

    Your header row delimiter is the character(s) at the end of the header row. This is usually the same as the row delimiter. In this case, {CR}{LF}.

    The comma is the column delimiter.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply