I have 5 different access databases 2010731 ,2010831
,2010931 ,21001031, 20101131
within each database there are 3 similar tables, employee, customer, sales.
Each table has a reported date column. as you can see each db is named in date format. so for example 2010731
employee table has multiple dates within the reported date column, I only want to get the data for 2010731, so a sql like select * from 2010731
where reporteddate like '7/31/2010%' would work.so 2010831
i only want employees that match 2010831 in the reported date column. this method would apply to customer and sales table.
How can i write a SSIS package that will loop through each Access db located in those 3 tables and only return data for the reported dates that is assigned to the the specific db.