If you’ve got several sources of data that you need to get into a database, you don’t have ... interval makes sense. Flat File Import into SQL Server Now that you’ve automated the fetching ...

We use linked servers in SQL Server 2000 (I know ... massage the data, and import into a database. You should have client access, which is the PC to AS400 connection software.