I am reading from a remote SQL Server and writing to my local one. I have
only got SQL username and password for the remote server. The package works
when run interactively. Is MS trying to be too clever and complaining
because it can't windows authenticate the remote server? or am I missing
something. Scheduled jobs which act only on my local server work fine.

The task is merely to use a select query to take data from a table on the
remote server and append it to an existing table on the local one.

Ian

In article <#kUsXo6eDHA.1648 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Ian
<ian (AT) RE (DOT) MOVE.invalid> writes
The most common issues with scheduled packages are around
permissions due to the execution context and the location of execution-

INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?kbid=269074

Support WebCast: Data Transformation Services Package Scheduling - An
Inside Look
http://support.microsoft.com/default...s/webcasts/wc1
02301/wcblurb102301.asp

I would also recommend you turn on logging within the package, either to
and error file or to a SQL Server (SQL 2000 Only) to get as much
information as possible

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org