Using SSIS To Copy Several Tables From One Database To Another

1) Scenario
Source Oracle database with 400 tables, each table has a field 2 common fields
Change_date and Company_ID


2) Required
To copy 50 tables to at least 2 different SQL Server databases based on the
Change_date and Company_ID

for Compnay_ID = €˜A1€™ and Change_Date = Last_Working_Date , copy 50 tables to Database1
for Company ID = €˜A2€™ and Change_Date = Last_Working_Date , copy 50 tables to Database2

Also I am not copying all the fields from each table, just a subset of fields

3)What I have done so far to create Database1
a) Created a SSIS project
b) Create 5 individual packages for the project.
c) Each package has 10 pairs of OLE DB source to OLE DB source representing the transfer of data for 10 individual tables.
d) For each data source, I use SQL command as the data access mode

E.g
Select field1, field2, fiedl10 from Table1 where Compnay_ID = €˜A1€™ and Change_Date =
Last_Working Date


4) What I want to do
However, since the where condition is the same for all tables (Compnay_ID = €˜A1€™ and Change_Date = Last_Working Date) , I want to find a way to set this as variable, so if the where condition changes, I only have to change it once.

Any assistance with this would be greatly appreciated.





<!--[endif]-->