Hey, Gift, would you mind posting the link to that thread? I'm studying for the exam as well and any understanding of the "beneath the hood" stuff would come...

Yeah, I wanted to sign up for the 2008 admin, but all the spots had already been taken. Oh, well. @=)

There are several places you can get good question / answers. Some of them you have to pay for.

Transcender is a good practice test with flash cards,...

The best way to pass these case studies is to skim them quickly, then go to the questions. You can always access the case study info while you're in question...

MCTS only requires the passing of 1 exam. So I would go with one for 2005 because it's not like you have to take several exams to pass it. ...

2 FYIs.

First, this site does not encourage, nor ever will, using dumps to pass exams. Even the site moderator will tell you so. If you want dumps, please...

We had a similar problem almost 2 years ago when we upgraded from 2000 to 2k5 32 bit. It turns out that there was something in our foundry or...

As I said in my previous post, you're going to have do another convert.

You can try to do it all in one task, but you might need two Derived...

Figured it out. You do have to do a manual transformation of the columns in question. You can either set them to what you want the DEFAULT to be...

Jack,

That is a SWEET workaround for NULL. I didn't even know about it and I just happen to need it.

Thanks!

EDIT: And you know, as soon as I posted...

You can't cast a NULL value as a specific datatype. It's either NULL or it's not.

Secondly, you can't mix strings and datetime values in SSIS. So either pick a...

You're in the wrong forum for that question. Repost in the Reporting Services forum and you'll probably get an answer quicker.

Yes, I am a woman. @=)

The HTML renderer isn't exactly the best in SQL 2k5. Rumor has it that it works better in 2k8, but as I haven't played with...

Delete or rename the .dll on the server where it's not working. Then add a copy from the server that is working and re-register it. It could be that...

I wasn't exactly sure what you meant by your previous post, but this last one clarifies what you're actually looking for.

The other solutions would be to:

1) break up your...