I was able to write a Perl Script to scrub the data out of the hourly SFTP files, and load them as records into our SQL DB.