Post reply

Loading from a txt file in SSIS

  • September 3, 2018 at 8:05 am

    #376843

    Hi Experts , i am trying to load from txt file to a table in a database.On flat file file when i preview  to sample the data all 12 columns are showing as one column.
    Please help how can i fix this.I want the preview as 12 columns not just one  long column.

    Thanks

    T

  • September 3, 2018 at 8:06 am

    #2004265

    Hi there,

    Do you have some kind of column delimiter you can use to split into the 12 columns?

  • September 3, 2018 at 9:02 am

    #2004271

    The delimiter is greyed out only row delimiter i can change.

  • September 3, 2018 at 9:13 am

    #2004274

    In your flatfile what is the delimiter?

    You should be able to reset columns within the flat file connection manager, and then choose the relevant delimiter.

  • September 3, 2018 at 9:23 am

    #2004277

    tmmutsetse - Monday, September 3, 2018 9:02 AM

    The delimiter is greyed out only row delimiter i can change.

    In your Flat File connection manager, have you got 'Format' set to 'Delimited'?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 5 posts - 1 through 4 (of 4 total)

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