Post reply

Unformatted flat file to table using SSIS

  • March 4, 2009 at 10:06 am

    #131491

    Hey

    guys

    I have flat file like this, no comma delimited and what soever, it has space that separate the data, and when i try to use the connection manager, it shows the half of the data as one column and remaining data as second column

    Flatfile.txt look like this

    aa bb cc dd ee ff gg

    hh ii jj kk ll mm nn

    How do i export this piece of data into table, where flat file

    connection manager shows 2 sets of column instead of 7

    that what i was expecting?

    Thanks

    simon

  • March 4, 2009 at 4:14 pm

    #953680

    i found my answer on my own

    Under the Flat file connection manager, select the ragged right under format lookup and select option columns and it will give actually a scale screen where you can pin point where your column starts in your flat file to table . SSIS is great , people we just have paly around and study

    Thanks

    Simon

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

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