I can run DTS package successfully if I run them in
Enterprise Manager manually. When I try to run it from
Query Analyzer or Stored Procedure I getting to errors.

The following is execute command for DTS:

Exec master..xp_CmdShell 'DTSRUN /S(CLAIMPRO) /U
(claimpro) /P(claimpro1) /N(DTS_MasterSearchDuplTest)'

Error message is generated:

DTSRun: Loading...

Error: -2147008507 (80074005); Provider Error: 0 (0)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services
(DTS) Package
Help file: sqldts.hlp
Help context: 713


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

Thank you

xp_cmdshell uses the cmdexec account to execute all command line functions
(or the proxy) , depending on your settings, that account may not have the
appropiate permissions to 'access' the DTS created connection objects (this
assumes your connection objects in DTS are set to us a trusted connection).

The userid and password you specify in DTSRUN has nothing to do with the
runtime security, only to do with the fetch of the package.


"arahman (AT) healthplus-ny (DOT) org" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:0ef701c3be6e$9f2025b0$a501280a (AT) phx (DOT) gbl...

In article <0ef701c3be6e$9f2025b0$a501280a (AT) phx (DOT) gbl>,
"arahman (AT) healthplus-ny (DOT) org" <anonymous (AT) discussions (DOT) microsoft.com> writes
Take out the brackets, as they are not valid delimiters for DTSRUN
parameters. If you wish to delimit the parameters try a double-quotation
mark.

To help generate valid DTSRUN command line strings try using the
DTSRUNUI tool. Select the options required and then click Advanced,
which has a Generate option.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org