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
Rea

Hi

Have you tried logging in as the SQLAgent service account and running the
job/checking out the ODBC driver?

You may want to try running the job from an NT scheduled job as your ODBC
driver may require interaction with the desktop (for some reason!) or that
the DSN (if you are using one) is not accessible.

John

"Rea Peleg" <rea_p (AT) afek (DOT) co.il> wrote