my DTS has activex script task which is to call a web service (the web
service is running on different machine). When I execute the DTS
Package, it succeeds. But if I execute the job to run DTS, I got the
error

DTSRun: Loading... Error: -2147467259 (80004005); Provider
Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied. Error
source: Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0. Process Exit Code 1. The step failed.

The job runs under domain admin, which has controls everything. And I
don't have any connection to any database in dts.

Thanks

In message <1114640127.421107.19900 (AT) l41g2000cwc (DOT) googlegroups.com>,
mhuynh5 (AT) hotmail (DOT) com writes
The server name in the job cannot be found or resolved. The error means
DTSRUN cannot load the package, because it cannot find the server. Check
the command in the job,


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

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

Thanks. That was the problem. We deleted the job and reschedule the
package and it works

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote