Great article. I was wondering if there is a neat way to force the run order that the sql scripts for the database. Often one script is dependent on another....

I believe it's the fact that the user is not logged on that is the problem for Microsoft (and our Prod Support Team). I have also heard of people running...

A word of warning. We had this requirement at the office recently and the production support team noticed that the driver is only supported "provided the SSIS jobs run in...

Dear Miss N,

I've tried it out and you can reference a SSAS 2008 cube from a SSRS 2005 report. So I guess that's good news for both of us!

Sean

There's no problem using SQL 2005 as a data source for SSAS 2008.

I don't know about using SSAS 2008 as a source for SSRS 2005, but it's one of the...

Hi Christo,

In order to avoid deployment issues click on your project properties in BIDS and under Deployment Server Edition select Standard.

That way the development environment will only allow you to...

Yes, you're right. He says:

Also new record and updations should also be updated in this database as soon as it is updated in any of the four databses.

I would suggest using a UNION clause to import all four tables in the first instance. Then use triggers to replicate updates or additions.

It's used whenever you need to quickly get a representative sample of data from a large data set for testing purposes.

It's especially useful when you're developing data warehouses as...

Hi Keith,

We need to do something very similar. Did you manage to get this resolved?

Thanks,

Sean

The main page is here: http://www.microsoft.com/bi/products/proclarity/proclarity-overview.aspx

However I have heard that it has a short shelf life and that it's functionality will be incorporated into PerformancePoint Server.

Sean