Mike hi, I think you maybe using the incorrect toolset, for although Visual Studio provides options for generating models based on MSAS 2005 databases, it doesn't (or at least I...

Ben, thanks for your response. I'll have a play with perspectives, see what they can deliver.

Ben, good point.

I'm not keen on "cluttering up" the cube. Most of the cubes we supply to customers have in excess of twenty dimensions and this can be daunting for...

Hi guys, thanks for your responses. It turns out, and I am ashamed to even mention this, I was using an incorrect spelling of the SQL2005 instance in the connection...

Simon & Greg, thanks very much for your input, it's much appreciated.

I'm starting work on the migration next Monday. I'll post-up any interesting issues I encounter.

All the best.

Duncan

Hi, this is a script I have used to create a stored procedure that builds a calendar table between any two given dates. You may find it useful.

SET QUOTED_IDENTIFIER ON

GO

SET...

Hi, you might also like to try the sendmail stored procedure, xp_sendmail, details in BOL.

Hi, I have not tried exporting data to a spreadsheet on another server but do, regularly, export to a spreadsheet on the same server as SQL Server. I then use...

Hi, using structured staorage files is a useful way of transporting packages from installation to new installation. However, if you have password protected your original package, when saving it as...

Have you migrated the repository to a SQL Server database?

I believe by default the repository is held in an Access file. In your case this may have become corrupted. Stopping...

Hi, I regularly have to create time dimensions and have scripted a stored procedure to do just that. The procedure creates a table called ext_calendar and takes two arguments; the...

It sounds like the SQL Agent might not have a fully functional email account.

When you run xp_sendmail from QA it runs using your email and domain credentials, when run as...

Hi, just a thought. If no data is to be left at all you might consider scripting the database in Enterprise Manager.

Select the database in question, from Tools select Generate...

Hi, you could also use the DTS run utility from the DOS command line prompt.

I have used this to allow users to run packages on demand without them having access...

Hi, have you tried double-clicking the errored line? What happens?

DAL