I am using my workstations console when running it manually, but the SQL Server Agent is running under the right credentials as far as I know (the agent is running under the same credentials as me).
Nick
I am trying to convert several tables from Paradox 8 to SQL Server 2000. Why run the DTS Manually, everything works fine, but when I schedule the job, I get the following error:
Copy Data from Results to Results Step, Error = -2147467259 (80004005) Error string: External table is not in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.