I have a dts package that I created which uses an odbc connection to go and copy a dbf file using visual fox pro drivers. The package runs fine when I execute it. But whenever I try to use the sql server agent to run it as a job I get an error saying that the dbf file does not exist. I have about four other jobs which run fine but this is the only one using an odbc connection.
Thanks for the help