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
 
Top