Hello Pasha,

You can most definitely do that. Hopefully the names are identified in such
a way that you can tell from one month to the next which table is which.

If you can programmatically determine the name of the table then you do not
even need to loop through the tables collection. You could build the name
of the table in a script task and populate the property (SourceObjectName)
of the transform Data Task.

You can follow the same kind of steps for the name of the Access mdb.


if you must loop through and look for a pattern then sure you can do that
as well.

You could use the ADOX library

http://www.sqldts.com/default.aspx?288

http://www.motobit.com/tips/detpg_listdb/


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com