You could use Excell to view your cube outside of AM.

Regards,

Nico

My first guess would be that the product is located twice in the product dimension source table. Once with Group 1 and once with Group 2. Maybe you...

We developed our own ETL tool.

And have used it at several clients of use.

More info: Contact Cronos.

http://www.cronos.be

Can you tell me how you got SP2 installed on the MSDE? We have several projects were we tried to do this but when we go and look at...

My other statements all work fine with the isql command. It's just that with this statement he seems to let the TableResults option out of the statement...

I've found the problem. There were several update triggers on the table, and my trigger was the last one to be fired. Because there were several other triggers...

Try this:

sp_changedbowner

-> Changes the owner of the current database.

Syntax:

sp_changedbowner [ @loginame = ] 'login'

[ , [ @map = ] remap_alias_flag ]

G,

Nico

Hi,

First of all the update statement in the trigger is incorrect.

You can't update the tables inserted or deleted.

What you are trying to do is also more complex than you would...

Judy,

Are you using the local system account to start the agent or a domain account? Maybe that the problem lies there?

Greetings,

Nico

We have to load data from several tables in several other tables.

We do this cursor base because an error may not stop the loading.

The procedure just has to log this...

If you mean command prompt when you say cmp prompt:

Then I get a login failure for my user account.

Otherwise what do you mean with cmp prompt and QA?

Nico

I've tried it, but I still get the same result.

Nico

I have the same problem. But I think I can't use the suggested solution because I have to set global parameters in the dts package.

Can I do this from...