Hi folks,

I'm having an issue scheduling a package in Sequel Server
2000. The package executes fine, but for some reason it
won't schedule. I've logged into the server through
terminal services and can get the package to run in there
as well, however no luck when it comes to scheduling the
package. I even have it scheduled in the development
environment, but now that I'm moving to production I'm
having trouble. Does anyone know if this could be a
driver problem? If not, any ideas? I'm able to connect
to the Oracle database through SQL Plus though???

Thanks for any help,
Brian
shererb (AT) msx (DOT) upmc.edu

In article <55f901c37c8d$d8fedc40$a601280a (AT) phx (DOT) gbl>, Brian S
<shererb (AT) upmc (DOT) edu> writes
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