Hi group,

We use DTS packages with processing tasks inside to process cubes. We call
these packages from the command line with DTSRun. So far so good, but I
haven't been able to find where the connection string to AS2K is stored. I
need that to set the execution location in order to make sure the AS box is
doing all the work, instead of the SQL box.

Can you help me out?

Thanks,

Coen

Processing is ALWAYS done by the msmdsrv service process.
Execution location applies to queries; not processing.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Coen van Houwelingen" <coen.van.houwelingen (AT) atosorigin (DOT) com> wrote in
message news:uWuGc.6$jP1.148 (AT) ns2 (DOT) gip.net...

On Tue, 6 Jul 2004 17:33:56 -0700, "Dave Wickert [MSFT]"
<dwickert (AT) online (DOT) microsoft.com> wrote:

OK, thanks for that. How come then, that we see the CPU load and the
RAM consumption going up on the SQL Server box that we use to store
and run the packeges? To make this clear: there's no AS on this box.

Coen

"Coen" wrote:
The processing causes a SELECT to be run against the cube's source database, which has some CPU cost. Is the source database on the same machine as the DTS packages?

-- J

On Wed, 7 Jul 2004 23:02:01 -0700, Jonathan Levine
<myfoo (AT) nospam (DOT) nospam> wrote:

far away.

Coen