Thank you for your reply. I had tried the 32-bit runtime and I still had the issue.

I started by project over from scratch and slowly added one small piece at a time. I finally got the error when I entered the query from Access as the data source. It is a pretty complicated query with lots of joins and functions. I'm not sure what is causing the issue but when I just exported a table or a simple query I had no issues getting it to run with the SQL Server Agent. The strange thing is the complicated query works just fine as the source until i try and run it with the SQL Server Agent. Oh well, go figure. Thanks to anyone who took a look at problem and gave it some thought.

-Nick