I have created a dts package to transform a foxpro .dbf
(located on another server) file - the package executes
on it own without error but if I schedule the package to
run it gives an error and says the .dbf file does not
exist - I have changed the user account for the SQL agent
account to one with domain admin privaleges but it still
throws the error. Any suggestions is appreciated. Thanks

Are you using a UNC path for the dbf? The place to start
troubleshooting this problem is:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

On Mon, 10 Nov 2003 08:33:06 -0800, "Eric Johnson"
<ejohnson (AT) addinc (DOT) com> wrote:

Thanks - I am using a UNC path to conect to the .dbf file - the link you
gave me is very helpful so I will run through these steps.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!