Hi Felix,

As far as I know, you can use SMTP with SQL Mail to send mail messages only and not to download messages. SQL Mail is not a mail server.

Regards,

Yaniv

Hi Vandy,

Can you please explain a bit more on your requirements? What type of parameters do you currently have and what are you trying to achieve. It is a bit...

Cory,

From the looks of it, the cube you have is not that big at all, and from the stats you provide, the msmdsrv service does not even begin to utilize...

Hi Cory,

Can you please provide a bit more data on your environment? is this a 32bit/64bit server? Where did you place the data folder for SSAS? What are exactly the...

Vassili,

What exactly do you mean by "migrating the enitre database as a cube"? Generally speaking, when you migrate a cube from 2K to 2005, the calculated measures will be migrated...

Hi Sean,

You can also use the 'Dynamic Properties' task to change data sources, initial catalogs, connection strings etc. This way, if the new database has the same structure, you will not...

Thanks Steve for your reply. The REAL project document did "inspire" me to write this article, and I indeed thought it would be helpfull to elaborate a bit on this...

Hi Shahab,

This is probably a security issue, meaning the user who is running the DTS does not have sufficient permissions to connect to the OLAP server.

HTH,

Yaniv

I agree. If it fits business requirements, its fine. In SQL 2005 perspective, with the new SSIS architecture, you can achieve much more functionality then you used to with the DTS...

Hi Ben,

Dimension structure in SSAS2005 is a bit different. To create a proper time dimension, you will have to add attributes (year, quarter, month etc.) to the time dimension, then...