DTS Package from Stored Procedure

J

Jerry

When I run the following line of code in a Stored
Procedure on an Access Project:

exec master..xp_cmdshell "DTSRun /S""(xxx-26GK921
\zzzzzJDEV)"" /E /NImportEntity"

I get the following error:

output
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


Have searched around Technet, MSDN and Google without much
luck. Has anyone experienced this before?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DTS Package from Stored Procedure 0
Run a SQL Stored Procedure from VBA 0
The stored procedure executed successfully but did not return any records 4
Urgent Help about SQL Server Connection 1
dts packages and xp_cmdshell 1
errors when accessing from a shedlued DTS SQL package 0
Can't connect to local SQL Server 2005 from .adp 7
Stored procedure recordset not opening 9

Top