ETL and Data Integration tools - Modern ETL software for everyone

Hello.

We have about 100 and growing flat file databases from Faircom (Ctree Server). I have the ODBC driver and was already successful at creating the export/import form it to SQL Server Express 2005 using the Visual Importer.

My questions are related to scalability. Since I have 100, would I have to create 100 packages that did the same thing or could one package use some sort of input file(that contained a list of the directories or DSNs) and ETL
the data?

I would want something to be able to be run on a scheduled basis although not sure it needs to be a service.

That's about the main goal at this point. Any suggestions?

I might also be interested in the BI tool.
Cris

You can use use package variables to change conenction parameters dynamicaly

There are some examples in the documentation

Mike

Or

Is is the only option to use a lot of DSN?
may be you can just copy all the files into one directory
so you can use the one DSN and specify the the mask to find the tables to load

or there is another option

create temporary directory
create dsn to point to this directory
creation import script to load data from this dsn

copy files from directory 1 into temporary directory

Load data

copy files from directory 2 into temporary directory

Load data

ETC

Peter