Post reply

Combining 2 Columns from 2 Sources

  • January 23, 2014 at 3:04 am

    #282721

    Hi Guys,

    Run into a problem. I got 2 text files that needs to be combined to produce an output. These 2 files has no relationship with each other. But they do both have exactly the same rows. How can I merge this 2 into one output?

    For Sample:

    Text File 1 contains:

    Col1

    A

    B

    C

    Text File 2 contains:

    Col1

    D

    E

    F

    The result set that I want is:

    Col1 Col2

    A D

    B E

    C F

    How can i do this using ssis?

    Thank you very much.

  • January 23, 2014 at 3:11 am

    #1682680

    You could add a row number (using a script component) to both flows and then use the MERGE JOIN component.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 23, 2014 at 3:45 am

    #1682693

    Koen Verbeeck (1/23/2014)

    You could add a row number (using a script component) to both flows and then use the MERGE JOIN component.

    +1

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • January 26, 2014 at 6:46 pm

    #1683406

    Thanks guys! that's definitely a good idea! Cheers!

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

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