Mark,

If possible I want to try to automate the whole process like we do in our current application with SQL server. There is no user intervention other than the copying of data files into a folder on the processing server.

Have you ever looked at firing the SQL Loader from an SP using an ODBC call to that SP?

TIA