So I don't really know what is actually being fixed, but by rebooting the server, the ETL process now runs successfully when I run it manually and when run as part of the nightly scheduler. Perhaps there is a hung process or other programs running that are absorbing the resources?
Any other thoughts as to how rebooting a server fixes this issue? I have seen many postings about this error, but with no resolutions.