I have a DTS that I have parred down to just a SQL connection. The
connection is set to use the ip\instancename,port

I can create the package on my local workstation, and using disconnected
edit put in the ip information. Since the server is behind a firewall and I
see a nated IP.

The issue is that when I schedule the package from my workstation I get the
following:

Executed as user: CLIENTEDS\clustadmin. 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.

When I schedule from the server and run the package it works. The ip and
instance must be correct so what is generating the error above. Any ideas
would be appreciated. I am using NT Authentication for the connection and
running the package as the same user both times.