scheduled dts return's 0 rows..

Hi all
After scheduling a dts, which retrieves data from a priority-tabula server
(using the tabula propriatary odbc driver) , no rows are transfared.
There is no error massage i can trace in sql server or in any of its logs,
the job just passes gracefully by the dts data transfare tasks, which all
return 0 rows..
If I execute the dts manually all is well...
Both the sql server and sqlserver agent user accounts are the domain
administrator.
Any idea will be greatly appriciated!
I've been fighting this phantom phenomena for a very l o n g time and still
have no clue.
Thank you
ReaRea,
to test if this is an authentication issue, can you log onto the SQL Server
box as the same Domain user that the SQL Server Agent uses and then manually
run the DTS package. This should be physically done on the server box. I'm
expecting that this will re
turn zero records, but let's see... . If it doesn't return any rows, then tr
y running the job manually as you reported in your first post and again log
in as the SQL Server Agent's login. This will tell us if it is related to th
e existence of network shar
es etc.
HTH,
Paul Ibison