dts retrieves 0 rows when scheduled...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rea Peleg (rea_p_at_afek.co.il)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 17:04:52 +0200

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

Relevant Pages

  • dts retrieves 0 rows when scheduled
    ... After scheduling a dts, which retrieves data from a priority-tabula server ... There is no error massage i can trace sql server or in any of its logs, ... job just passes gracefully by the dts data transfare tasks, ...
    (microsoft.public.sqlserver.datawarehouse)
  • scheduled dts returns 0 rows..
    ... After scheduling a dts, which retrieves data from a priority-tabula server ... the job just passes gracefully by the dts data transfare tasks, ...
    (microsoft.public.sqlserver.server)
  • Re: ActiveX DTS not working on Schedule
    ... DTS package. ... comes with SQL Server due to the bug in 2000 which corrupts the DTS ... '  This script uses FTP to move a file from the transfers directory ... If not errorlevel 1 If not errorlevel 2 goto 226_ok ...
    (microsoft.public.sqlserver.dts)
  • Unable to enlist in the transaction.
    ... When i execute the same DTS job on another server not running SQL Server I ... Unable to enlist in the transaction. ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: using access schema ini with DTS
    ... and yes I refresh the access database... ... SQL Server and with a scheduled event. ... Col2="PartNumber" Char Width 16 ... Underneath the covers of a DTS ...
    (microsoft.public.sqlserver.dts)