let's say there are 30 tables in server2 like TableB and 30 tables in server1 like TableC.

let me map it.

server2-------------server1

TableB--------------TableC-----same columns

TableD--------------TableE----same columns

TableF--------------TableG----samecolumn

say there is one table in server 1 to match a table in server 2

but they will all(60 Tables) have a column GROUP_ID.

when I run the SSIS package only those records should be moved to server1 from server2 which have Group_ID that has STAUS ='READY' on TableA (on server1).

one time I may have to load the Tables in server1 for STATUS='READY' next time it might be STATUS='NOT READY'.

instead of hard coding the status inside the components like 'Lookup' or 'SQL TASK' or similar(whichever works), I would like to set a parameter where I can input the status and it applies for all the tables.

I don't know if I made it more confusing or clear!!

if you still didn't get it, let me know I will try to explain in a different way.

thanks.