Hi ,
I have 60 tables related one source. In the same number of tables available in the multiple sources.
I need to run the job sequentially means one after other source.
Here my table structure is same across the all sources. If I develop the ETL for the one source system I should use the same by changing the source & target. Here I am changing the source & target as I am running in the same job. So I cannot use the data store configurations.
I have lookups in the data flows. If source 1 data flow should use source 1 lookups only. Source 2 flows use source 2 lookups only…
But for me here If I replicate the flow then I can change the source target with less effort.
But If I am going to change the lookups I need to visit the each lookup and I need to change as data store is different for each source. Here I have 27 source systems.
If I am going to visit like this is almost same as building the flow .
Could you please give me any idea to change the lookup tables data store in the flows.
Thanks & Regards,
Ramana.
Ramana 
(BOB member since 2009-04-30)