Robbert Hof (1/13/2009)

---

If you did not update your books online then you missed this one:

...

Changed content:

Corrected technical error to clarify that you cannot bring a filegroup online when a...

I'd say you take a good look on the score report, it shows which areas you scored better or worse.

Besides that: when taking exams most of the times I...

Is there "a more elegant / efficient way of doing this"? That's something I have asked myself a couple of times with these kind of questions.

Most of the times it...

Could it be that email-relay to external addresses (outside the domain) is prohibited on the emailserver, and that the email therefore is not sent ?

It depends a lot on what datatypes you have imported from the DB2 source.

If they are both datetime you can use dthe DATEADD and DATEPART functions as Franky says, for...

I have little experience in migrating dts to sql2005, but I don't envy you for having 400 dts packages to migrate!

My info says you can do the import only one...

Gosta,

I agree that automating the client was one of the solutions I had in mind, that's how I started (using SQL / doing BI stuff) as well!

I don't think this...

Checking out Jamie's site is a must if you want to work on SSIS, lots of good stuff over there.

As for your requirement: I would use a For Each Loop...

If your question is: how can I set the default sortorder for a dimension(-attribute); the answer is that you can sort by

- key (the default, which is apparently not what...

You should be able to change the connectionsettings using VBA.

Below is an example if your workbook has only one pivotcache; you probably want to work out a better way to...

AFAIK there were also the Office PIA's, that made it possible to do this kind of stuff without (fully) installing Excel on the server.

Here they are: Office 2003 Redistributable Primary...

I think it is good that there are a more case studies in exams. They are totally gone from the 2008 exams i took so far, but i think they...

I suggets you begin with getting the sample extension from codeplex to work, en then tailor it to your needs.

There is also some documentation about this sample, end some general...

I took 71-452 two weeks ago, and I agree with Brandies remarks.

You have to have good knowledge about SSIS, SSAS and SSRS, and indeed your knowledge should be a...

I agree with most posters here: as you're currently working with 2005, and want to finish certification this year; stick to the SQL 2005 certifications.

However: don't think there's nothing to...