Post reply

Recors in new line in Flat file Destination

  • August 7, 2015 at 1:56 am

    #303110

    Hi ,

    I have a requirement where I have to run a stored procedure and then create a flat file with each column having definite widths and each record in new line with no space after each record.

    I tried fixed width format but that doesn't put data in new line after each record.I also tried fixed width with row delimiter but that introduces a white space after each line which I do not need.

    Can anyone help me with this ,how to just get the records in new line without a space ?

    One way I can think of is use fixed width with row delimiter and then use a script task to read the file and remove trailing spaces from each line.

    Please help me with suggestion.

    Thanks,

  • August 7, 2015 at 1:41 pm

    #1818273

    Are you able to choose {CR}{LF} as a Row delimiter?

  • August 7, 2015 at 6:23 pm

    #1818325

    happy55 (8/7/2015)

    Hi ,

    I have a requirement where I have to run a stored procedure and then create a flat file with each column having definite widths and each record in new line with no space after each record.

    I tried fixed width format but that doesn't put data in new line after each record.I also tried fixed width with row delimiter but that introduces a white space after each line which I do not need.

    Can anyone help me with this ,how to just get the records in new line without a space ?

    One way I can think of is use fixed width with row delimiter and then use a script task to read the file and remove trailing spaces from each line.

    Please help me with suggestion.

    Thanks,

    If it's truly fixed width, the end of line character(s) should appear in the same spot whether that includes and spaces or not.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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