Post reply

Importing joined data into 2 tables with SSIS

  • December 4, 2007 at 8:13 pm

    #119594

    Does anyone know how I can do this?

    I have 2 tables in and ODBC datasource (INV HEADER) and (INV DETAILS). The relationship on these 2 tables is (INVNUM).

    I want to import these tables on a nightly basis by date. The problem is the date field is on the (INV HEADER) table and not the (INV DETAILS) table.

    Basically I want to import all the (INV DETAILS) rows that have the same (INVNUM) as the (INVHEADER) but don't know how to do this.

    I could use a join on the source tables but how would I direct specific columns to 2 different destinations?

    Any help on this would be great and appreciated.

    Thanks

  • December 5, 2007 at 12:42 am

    #757229

    I think the best way is use multicast component from ODBC source (joined SQL query as source of data). So place it on the Data Flow tab surface and add green path from ODBC source to it. Next to each output of multicast component add path to destination component and select mutually exclusive list columns from source for each path.

  • December 5, 2007 at 6:16 am

    #757311

    I'll give that a try.

    Thank you

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

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