Okay... That was an interesting experience.

Multiple choice & single choice questions only, 75 questions, not all are scored. 3 hours for the actual exam time limit (I guess the stated...

Sounds like the connection manager for that Execute Package task is set up wrong. Look it over and make sure you don't have any typos and that the location...

Job steps don't have sequence containers. Look under SQL Server Agent -> Jobs. Right click jobs (or in the white space of the Summary window in SSMS) and choose...

NP. Sorry I didn't have better news.

I just checked with the developer and he agreed with my comments. There is no way to role child packages back from a parent package.

Here's what we did.

1) Set up...

Have you enabled Package Configurations in the actual package? if so, have you actually added the ConnectionString property of the Connection Manager to the config file?

Just entering the string...

Not in my experience.

Usually what happens is that the SSIS package considers the "Execute Pkg" task as just a command to start the next package rather than waiting...

What type of job step are you defining and what parameters are you using?

Can you even create a new job? Where in the process are you getting stuck?

Case Studies take up about 50-65% of the exam (ISTR) and the rest is variations on multiple choice, single choice, and simulations (though these might be in the case studies...

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...