but you will need to export the data from the database, probably do an EBCDIC -> ascii translation, process the export so that it will import into SQL server, then import into SQL server.

This means that something as trivial as a sick day can result in a system or data problem ... whatever interval makes sense. Flat File Import into SQL Server Now that you’ve automated the ...