Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Job Tasks sometimes fails

Author  Topic 

rtr1900
Starting Member

48 Posts

Posted - 2009-06-18 : 06:45:45
Hi everybody,

i have a lot of jobs that import data from DBF to SQL. And lately I have trouble with one of them. It gives me an error. Althought if I do it by hand it runs fine. Just not when it is programmed.

Does anybody knows why? And also is there a way to see why (a log for example) it stops importing the file.

The files that has to be imported isnñt in use!
I always delete the table, creat it again and import the records. Am I doing wrong?

thx


chih
Posting Yak Master

154 Posts

Posted - 2009-06-23 : 02:19:39
If you are sa, it is no problem for sure. But does the application have the right permission? As you delete the table and create it again.
Go to Top of Page
   

- Advertisement -