Re: dts retrieves 0 rows when scheduled...
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/08/04
- Next message: Malgorzata Ndreu: "number of rows transferred by DTS task"
- Previous message: SqlJunkies User: "DTS Excel to Oracle: Buffer Overflow"
- In reply to: Rea Peleg: "dts retrieves 0 rows when scheduled..."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 16:59:35 +0100
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@afek.co.il> wrote in message
news:e%23grmLWTEHA.2416@TK2MSFTNGP09.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 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
>
>
- Next message: Malgorzata Ndreu: "number of rows transferred by DTS task"
- Previous message: SqlJunkies User: "DTS Excel to Oracle: Buffer Overflow"
- In reply to: Rea Peleg: "dts retrieves 0 rows when scheduled..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
