"Darren Green" wrote:

> SQL Server does not exist or access denied. really means it cannot find the
> server, such as when the server name is wrong. So what is the server name
> value used in the connections for the steps/task that have failed, and can
> it be resolved from the machine used to call DTSRUN?
>
> Note that DTS packages always run on the client, the which us actually
> running DTSRUN, they are not client-serrver in nature. The server you
> specify in teh DTSRUN command is just the storage location, used to load the
> package, nothing more.
>
> --
> Darren Green
> http://www.konesans.com | http://www.sqlis.com | http://wiki.sqlis.com
>
> "cheilig" <cheilig@discussions.microsoft.com> wrote in message
> news:5D8E3A09-E8A2-4086-B2F6-FC6FCCB24BBB@microsoft.com...
> > running DTSRun /S "servername" /N "package name" G/ "packageguid" /E
> >
> > DTSRun: Loading...
> > DTSRun: Executing...
> > DTSRun OnStart: DTSStep_DTSExecutePackageTask_3
> > DTSRun OnError: DTSStep_DTSExecutePackageTask_3, Error = -2147467259
> > (80004005)
> > 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
> >
> > Error Detail Records:
> >
> > 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
> >
> > DTSRun OnFinish: DTSStep_DTSExecutePackageTask_3
> > DTSRun: Package execution complete.
> >
> > The user has full rights to the DTS package and all connections within.
> > Any
> > thoughts why it is failing?
> > thanks,
>