Post reply

Using the Lookup Data Flow

  • May 19, 2006 at 11:40 am

    #112259

    I would like to use an Excel spreadsheet as a 'Lookup' data flow. But I don't see that as an option? 

    The scenerio is that I have data in a sql table that I need to perform a lookup against an excel spreadsheet to then use the lookup value to insert into another table in another sql database.

    Do I have to create a table and dump the lookup values from Excel into it in order to use the lookup?

    Or is there a different way to do this?

     

    Thanks for your help.

     

    Daniel

  • May 22, 2006 at 4:15 am

    #639185

    Hi Daniel,

    instead if both the SQL table and the lookup table are not very latrge (<100.000 rows) you could use a "Merge Join" component to join sorted data from an SQL and an Excel datasource.

    br, Markus

  • May 23, 2006 at 2:25 pm

    #639602

    Thanks it worked but a little cumbersome.  I had to add the Sort Data Flow Tasks, but it worked.

     

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

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