Post reply

Add a column with a value from another source

  • January 29, 2013 at 1:52 am

    #288469

    Hello there,

    i'm using SSIS 2012 .

    i have 2 sources ( xml files) in 1 data flow and from each source i have data .

    from source A i got multiple rows with 2 columns.( name,age)

    from source B i got only 1 row and 1 column (CITY)...means i have only one value which is "NYC"

    i want to eventually to join the city (again,there is only 1 value) to the other data (name,age)

    the result would be:

    name, age,city

    jenny,17,NYC

    bob,22,NYC

    lee,23,NYC

    how do i do that?

    thanks

  • January 29, 2013 at 2:41 am

    #1581957

    Try to use " Lookup Dataflow item"

  • January 29, 2013 at 2:43 am

    #1581958

    Guitar_player (1/29/2013)

    Try to use " Lookup Dataflow item"

    Lookup wont work since there is no common key between these 2 tables...

  • January 29, 2013 at 4:53 am

    #1582032

    You could try a MERGE JOIN from t1.name to t2.city, join type = FULL.

    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 31, 2013 at 11:52 am

    #1583129

    have that city column value into a variable and use derived column

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

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