Data transfer automation

Hi All,

I am uisng SQL Server 2000. I need to transfer tables in about 116 databases from AS400 to SQL Server.Is there anyway to automate this? right now I am creating DSN for each data source and using DTS to import tables from each data base. This work is too much for 116 databases. What is the approach I need to take in order to automate this task? Your help is greatly appreciated

Thank you,
Sam

You can run dts packages as sql job.