Post reply

Flat File (delimited)

  • July 12, 2009 at 10:31 am

    #131894

    i need to dump the flat file to a table and the flat file is in this format

    ~100~test~20-4-2009~

    when i do a delimited option with ~ i get like 5 columns in the column mapping

    first colum is blank

    second column is 100

    third is test

    fourth 20-4-2009

    fifth blank

    i want only three columns

  • July 12, 2009 at 10:59 am

    #1023622

    Hello,

    There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • July 12, 2009 at 12:15 pm

    #1023628

    Thanks it worked.

  • July 12, 2009 at 6:01 pm

    #1023665

    John Marsh (7/12/2009)

    Hello,

    There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.

    Regards,

    John Marsh

    🙂 There is a slightly more elegant solution. The problem with this method is that redundant data is fired through the pipeline. To avoid this, edit the flat file source and deselect the unwanted columns ...

    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 4 posts - 1 through 3 (of 3 total)

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