I tried to execute a SSIS package with dtexec with the following from my SQL
Server box, the package execution is successful.



dtexec /FILE "C:\Program Files\Microsoft SQL
Server\90\DTS\Packages\MapssIntegrationServices\Ma pssMartPackage.dtsx" /Conf
"C:\Program Files\Microsoft SQL
Server\90\DTS\Packages\MapssIntegrationServices\ma pssmart.dtsconfig"
/MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E



But when I tried to run from my client machine, (I have SQL Server 2005)
installed in my machine with the following. It throws the below error.



dtexec /FILE
"\\b10ftcctsql11\Packages\MapssIntegrationServices \MapssMartPackage.dtsx"
/Conf "\\b10ftcctsql11\Packages\MapssIntegrationServices \mapssmart.dtsconfig"
/MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E



Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.



Started: 11:16:17 AM

Error: 2006-07-17 11:23:18.56

Code: 0xC0012024

Source: Analysis Services to process MapssMart Cubes in ProcessDefault mode

Description: The task "Analysis Services to process MapssMart Cubes in
Proces

sDefault mode" cannot run on this edition of Integration Services. It
requires a

higher level edition.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 11:16:17 AM

Finished: 11:23:27 AM

Elapsed: 429.768 seconds



I am totally blocked due to this issue. Any pointers to resolve this issue
would be of great help.

Perhaps this previous post can help you:
http://www.microsoft.com/technet/com...=en-us&m=1&p=1

In short, are you sure your client also has SSIS installed (done during
setup) and not "just" the sql server engine?

I had a similar error with versions and forgot to install SP1 on the client
machine. Could this be the reason ?

"RAJASEKAR" wrote: