When you save a package with "Don't Save Sensitive" none of the connection passwords are saved.

You have to use one of the other protection levels. I'd advise "Encrypt Sensitive With...

GilaMonster (9/11/2008)

---

Brandie Tarvin (9/10/2008)

---

4 times the stupid thing terminated on me, twice during my review session. Always when I clicked the "next" button. Fortunately, it saved all my answers. Unfortunately,...

My team has had better luck with the XML Configuration files. But that's because we have clustered servers and the environment config variable got confused.

It's a toss up. Either way,...

Jacksonville, Florida.

As far as touching base, are they registered with this site? Do they have the ability to Private Message me?

Darnit. It's a shame you don't live in Florida. My company is looking for a good junior DBA.

You should know the basics of each. You don't have to be an expert, but if you don't even know the basics, any questions that may be on your version...

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