Lookup, Cache Transform and Index Position

• SteveD SQL

  SSCrazy

  Points: 2261

  More actions

  December 19, 2015 at 8:21 am

  #303389

  Hi All,

  I have a SSIS 2008R2 packages which is extracting data from a TXT file and insert/updating records in two tables (parent/child). I am using the Lookup in multiple data flows against different fields in , e.g. I need the primary key of existing parent, checking if records exists and if exists does it really need an update.

  Came across thread discussing cache transform and I thought I could use that. I would create a view which pulled in the relevant data from both table, load it into the Cache transform and then use the Lookups against that instead of Looking Up to the destination tables multiple time. I have two question regarding this...

  1) Is this a valid strategy?

  2) I am confused about the Index positioning. Again I have multiple lookup at different time looking at different field. Do I create multiple caches or one cache with all relevant field with an index position > 0

  Thanks

  Steve