Whats the use Ragged right in flat file connection manager in SSIS


  • hi..

    i am new to SSIS ....

    I want to know what is use of Ragged right and fixed length in flat file connection manager..

    When we should use Ragged right and fixed length..

    state difference and say the situation of where it can be used..

    thank you..

    Tuesday, June 29, 2010 6:09 AM

All replies

Tuesday, June 29, 2010 6:17 AM
  • hi Kumar,

    That was good...

    but i still need good tutorials for both...

    is there any other links..

    thank u...


    Tuesday, June 29, 2010 6:34 AM
  • "Ragged Right" is another option of File Type which is exactly the same as "Fixed Width", except that it gives you the option to insert a linefeed character (or CRLF, etc.)  at the end of each line of data.

    SSIS: Compare Ragged Right with Fixed Width

    How to Import a Comma Separated File into SQL Server



    Kapil Khalas
    Tuesday, June 29, 2010 10:09 AM