Steve,

I don't think IF...THEN...ELSE works in SSIS. That's why I'm trying to use the ? : conditional. And it's not evaluating correctly...

I'm trying to format an 8 character string into...

I'm a little brain-dead this morning. LZ?

Foresight

Bill_CCAC (10/19/2010)

---

Hi All. I'm hoping for ideas on how to make either my query more efficient of a better way of collecting the same result set. This query currently takes...

There was a museum downtown in the basement of one of the downtown office buildings, many moons ago. Which one is that?

John Rowan (10/19/2010)

---

Isn't Durham downtown?

There's one on 10th or 13th... (10th, I think) when you're heading out of downtown and towards Bellevue. It actually...

I'm not really good with the scripting code, but I have an alternate suggestion. 2, actually.

Pull the data into a temp table with an identity field and then use that...

Henry Doorly (sp) Zoo. Beautiful place.

Fontinelle Forest (for hiking)... Lots of huge parks in the area....

Been there. Beautiful place.

Marv-1058651 (10/19/2010)

---

I would love to add some results and ddl, but unforutantely, I am dealing with patient data. I can dump some dummy data to display instead. Here is the...

That right there might be the problem. I don't know if SQL Agent is actually needed for the install, though.

I would just like to let everyone know that I live very green.

My sheets are green, my clothes are green, my food is green, my cats are green... Oh, wait....

davidandrews13 (10/19/2010)

---

Brandie Tarvin (10/15/2010)

---

Not a horror story, but definitely a cringe moment.

A job where the Dev instance was on the same server as the Production Instance. SQL Security was not...

Roy,

What is it deadlocking?

What exactly is the question? @=)

Is there a difference between the service accounts used for the other instances and this one?

If so, are you sure the accounts have the necessary permissions for installation?