I wan't to run a dts with a stored procedure using xp_cmdshell and
dtsrun.

The thing is if i run dtsrun.exe in a command prompt it executes
succesfuly, but if i use xp_cmdshell it gives me the following error:

DTSRun OnError: DTSStep_DTSDataPumpTask_1, 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

If i use dtsrun on a workstation or in the server both run ok, if i use
xp_cmdshell in either workstation or server (in the QA) gives me that
error.

Any suggestion is welcome.

By default, only sysadmins can execute xp_cmdshell. Could this be your problem?

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk


"arnoled" wrote:

I'm logging to the QA as sa. And as an adminitrator to the server
(terminal server).

i tested something else: i made a dts that uses the same server for
source and destination. And it worked.

So the problem is when i connect to the other server. It's weird
because i'm runing through enterprise manager and in the command shell
and it works fine, but with xp_cmdshell gives me that error. All tested
from the server.

To make clearer (server 4 is the one that has the dts):
EM DOS xp_cmdshell
Server 3 ----> Server 4 OK OK Error
Server 4 ----> Server 4 OK OK OK

The dts only copys one table to another

Sorry for my english, thanks.


Charles Kangai ha escrito: