We are trying to run a job scheduled on SQL Agent that has only 1 step. The
step is an Operating System Command of:

DTSRun /s <Server> /n NEW Email Team Managers /e

which attempts to run a DTS package. The DTS Package itself has only 1 step
which is an ActiveX Script Task. The task connects to a database, runs
through a few records and sends emails out.

Since moving this process to a new server, the job will not run via SQL
Server Agent. The history view of the step provides the following
information...

"Executed as user: <Domain>\Services. 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."

For info: We get the same if we use the command line with a username and
password (/u username and /p password rather than /e in the command line).
Also SQL Server Agent does run another DTS package that contains T-SQL and
transformation steps.

The /E and /S and /U just connect you to the SQL Server to be able to
retrieve the package nothing more.

Have a look at this article

http://support.microsoft.com/?kbid=269074


"gogerc" <gogerc (AT) discussions (DOT) microsoft.com> wrote

Thanks for the response Allen but we have seemed to fixed the issue now our
selves. But thanks for the Link in creating DTS Packages.

Carl

"gogerc" wrote: