Hi All,

I have an ODBC datasource that I use as the connection for
a dts package and wish to schedule that package. However,
I haven't been successfull in scheduling such a job. Are
there issues with using an ODBC connection in a scheduled
job??

Not necessarily issues but you need to remember that it will
be running under the security context of the SQL Agent
account and it's running on the server. When you test it
from your PC, it's running on your PC and under your
security context. Issues related to this are typically what
causes problems when running DTS packages as jobs. Packages
execute on the PC where execution was initiated and under
the security context of whatever user executed the package.
In terms of the DSN, you also need to make sure that you set
up a system DSN on the server with the same settings as
whatever you had set it up with on the PC where the package
was being executed.

--Sue

On Mon, 3 Dec 2001 13:50:40 -0800, "Terry Pino"