dts retrieves 0 rows when scheduled

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 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
Reawhat is the result if you schedule your package in a Windows scheduled tasks
instead-of SQL Agent?
have you try to change the DTS properties to make sur the thread run in the
same process? (sometimes if this option is not checked, there is some
problems to pass the identity to the components)
"Rea Peleg" <rea_p@.afek.co.il> a crit dans le message de
news:eWbHCLWTEHA.3844@.TK2MSFTNGP11.phx.gbl...
> 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 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
>