DTS Package from Stored Procedure

G

Guest

I wanted to repost with my email addess for possible
quicker reply.

I did not find any other posts with the same issue but did
see where there were two others wanting to accomplish the
same thing - Import a delimited flat file into a SQL Table
using a Stored Procedure. If no one is familiar with the
issue below maybe suggest another method to Run a DTS
Package from within a Stored Procedure Or a way to run the
VBA Command DoCmd.TransferText in a Stored Procedure.

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

exec master..xp_cmdshell "DTSRun /S""(xxx-26zz921
\zzzzzJDET)"" /E /NImportZZZ"

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?

TIA
 

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

The stored procedure executed successfully but did not return any records 4
Run a SQL Stored Procedure from VBA 0
DTS Package from Stored Procedure 0
dts packages and xp_cmdshell 1
ADP: Can't use stored procedure on remote SQL server 19
Stored procedure recordset not opening 9
Error Executing DTS package from MSACCESS 1
Stored procedure as row source for a combo box 4

Top