I want to launch a dts package from query analyzer. I'm using code like the
code below and am getting the error below. It works just fine if I use the
same exact code that is in @strsql from a command prompt. Any ideas?

Thanks, Andre

DECLARE @strCommand VARCHAR(8000)
DECLARE @nCubeID INT
SET @nCubeID = 99
SET @strCommand = 'DTSRUN /S SQL01 /E /NCube' + CAST(@nCubeID AS VARCHAR) +
'Refresh'

--select @strCommand

EXEC master.dbo.xp_cmdshell @strCommand




output


------------------------------------------------
----------------------------------------------------------------------------
----------------------------------DTSRun: Loading...
Error: -2147221005 (800401F3); Provider Error: 0 (0)
Error string: Invalid class string
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 713
NULL
(10 row(s) affected)

In article <eizLi7AnEHA.3296 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Andre wrote:

The error suggests as well as the use of the word "cube" in the string that
the location of execution does not have the dlls necessary to run the package.

Executing in the cmdprompt on your box then package is executed on your box.
Executed in the QA window of a connection to somewhere else then the package
will execute over there. Could this be the issue?




--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know