Post reply

Need to load double pipe || delimited data in a table by using SSIS

  • March 18, 2014 at 11:54 pm

    #396437

    Hello, Recently in an interview , Interviewer asked me below question :

    I have an Excel where data is Double Pipe delimited ( ||) then how can we parse the data and load it in a table by using SSIS.

    Like :

    ColumnA||ColumnB||ColumnC...

    When I map it directly with the table , it adds a New column between the existing columns, I think double pipe is treated a new column between the existing columns because SSIS understands single Pipe delimited data only. Like ColumnA NewColumn ColumnB NewCoulmn ColumnC.

    Please let me know the approaches to achieve it.

    Thanks in advance.

  • March 19, 2014 at 3:07 am

    #1698273

    When you choose your delimiter, don't select the | delimiter option, actually delete that out and type ||. That should get the behavior you want

  • March 19, 2014 at 3:24 am

    #1698278

    Thank you so much, it worked. Now I know why I am not selected in that interview :-):-)

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

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