Yes...make sure the pencil is sharp! Seriously, this is a subject that I just finished spending the entire weekend studying...and I am not sure if I am any closer to...

You are welcome! If you have any more questions, I am happy to help if I can...

Michael

Michael Weiss

If you set your date dimension table up with a surrogate key (say an integer identity column), then your foreign key column in your fact table would be of the...

I don't mean to sound cynical, but I would get rid of XP Home and install XP Pro...

Michael

Michael Weiss

Here is a link to a brief article and example of a fact table. Basically, you want your fact table to consist of foreign keys pointing to the dimension tables....

PS - If you need help writing the query, please provide the particulars of the data you are querying...table name(s), columns, which fields you need to include, date parameters or...

Hi Melissa,

If you click on the Wizards tool button in Enterprise Manager, one of the choices you have is Export Data. Select that, then select your data source. Next, set...

Once you have your global variables defined, you need to establish a 'placeholder' in your sql statement for them. In your case, the sql would look like, 'INSERT ##TEMP(field1, field2)...

SP2 for Analysis Services should fix this problem. It can be downloaded (free) from the sql server site at microsoft.com...

hth,

Michael

Michael Weiss

Your mention of Mcaffee reminded me of a problem I had with Analysis Services on my home PC about a year ago...traced the error messages down and found it was...

I think I would use an ActiveX task object and create a script that loops through your ini file. This script would then build a dynamic SQL statement and include...

There are a few ways to go about doing it...but perhaps the easiest way to start is to create another package...in this package place two Execute Package task objects...have these...

If you look at the three executables that make up SP2 you will notice that one of them is specifically for AS...

Michael Weiss

Look into setting an object reference to outlook...you should be able to walk through the object model and look for attachments that way...I would give you an example of code...

Is your email using MS Exchange? If so, you can use CDO via an ActiveX script to do virtually anything with your email that you can do through the GUI....