If the cubes are in the same database then you can use the LOOKUPCUBE function.

Or you could combine your datasets in SSRS by having adjacent tables with different datasets.

One of the parameters seems to be missing a value, impossible for us to tell which one.

I would however re-write this code to use a stored proc, rather than bulding...

when creating a new database they may need a server roles as well

for most of the time roles are the perfect way to go as you can set permissions down to the dimension member level.

setting them up is fairly straight forward, ...

as you are using 'sa' then then it shouldn't be a permission issue, I would compare the db options of one db that works with one that does not...

The template package that we use contains;

- a number of variables that are used for logging and error handling

- an initial execute sql task that logs the start of the...

are these databases that can't be accessed sql 2005 - 2008 ?

and your tool that was created before then can't understand the format of the system tables.

because the un-partnered brackets are confusing the number of arguments..

it look like you are missing the closing ')' for your first TRIM

Cowboy DBA (9/20/2011)

---

Seems to have been sorted. In the Excel source editor I changed the table source from the worksheet name to worksheet name $

So from "SourceSheet" to "SourceSheet$" and...

it could be a number of things,

in the data source, are you accessing Excel directly or have you used a query with a specified range that may need extending?

the...

Ninja's_RGR'us (9/20/2011)

---

steveb. (9/20/2011)

---

Ninja's_RGR'us (9/20/2011)

---

steveb. (9/20/2011)

---

wildh (9/20/2011)

---

Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to...

Ninja's_RGR'us (9/20/2011)

---

steveb. (9/20/2011)

---

never used...

if the number of 'sal' columns is fixed to Four then i would create Four seperate data sources, one for each column, and then send these all to the...

never used that methodology, ...