>I have SSIS packages written that uses the VFP OLE Driver. This works great in Integration Services but fails when I create an Agent job that uses those packages because the driver is not 64 bit.
>I am using SQL 2008.
>
>Am I just screwed here?

You can try to install and run 32-bit version of SSIS. See 64-bit Considerations for Integration Services for more info.