You can log users queries in SSAS, but this will not tell you how long people were connected to any particular cube nor will it detect any schema changes done...

Note that even if you specify a password in the configuration file set up (in the wizard), it will not be saved in the physical file. You need to add...

(4): there is no specific exception handling for the data flow task. This is where you can insert the "event handler" logic for any particular event you may want to...

It's unclear from your question if need to assign a value to a variable in the control flow. Assuming you are, you may want to use the "Execute SQL" task,...

Dude, this is not a question for a forum... In a nutshell, SSIS is the new DTS, but for further reading, go to BOL: http://msdn.microsoft.com/en-us/library/ms141026.aspx%5B/url%5D

You can use the Sort transofrmation which enables you to remove duplicate rows. This is one way to remove duplicate rows. Any particual reason you don't want to use SQL...

If you're using SSIS, it validates the schema that is used in the package before running. I hope I got your question right.

Plus, for updating dimension data, use the "Process Update" option for dimensions. If data is only added to your fact tables, consider partitioning the cube and fully process only the...

I'm assuming you need to populate a SQL table with the data?

If so, you don't necessarily need to use SSIS to do so, you can simply run a SQL script...

Excellent article! While I haven't tested any of the scripts mentioned, it does provide a solid background to this subject (one that I didn't get the chance to experience yet...)....

Hi Hannes,

You can find such a tool with SP2 for SSAS 2005.

Yaniv

Yes, synchronisation scripts can be saved and then embedded in a SQL job to be run at regular intervals.

The last step in the synchronisation wizard prompts you either to synchronise...

Hi Brandie,

A Star Schema and a Snowflake Schema are design structures, kind of like an ER diagram for a relational model.

A cube is an OLAP engine structure, which actually holds...

And your question is......?

Hi Jon,

As you've mentioned, it is absolutely recommended to have the data and log files placed on separate drives. However, I can't seem to think of any particular reason to...