I don't know Ruby, but that sounds like a doozy.

So you're getting the data you need now?

Patrick, look up Table Aliases in Books Online. You can indeed join the same table multiple times, but you can't have two tables with the same naming reference.

Table Aliases should...

Hey, I haven't talked to some of you people since ... LAST YEAR! Wow, it's been forever!!

(and now that my typical snark is out of the way)

I hope everyone's...

Gosh darnit.

On-the-fly resizing works, but my Writing Settings doesn't have a line count for the post box.

@=(

I guess I'll keep looking for the default setting. At least on-the-fly resizing will...

Stefan Krzywicki (12/27/2012)

---

No, I...

I am logged into my dashboard and do not see Options on my left-hand menu.

Is it hiding, perhaps, in one of the theme files?

Let me rephrase my question.

Are all these tasks occuring in the SAME dataflow task as task 16? Or are they all individual dataflow tasks?

arnipetursson, thank you for your script, but it's using the same tables I'm already using even if the SELECT is a bit different. The Blocked Processes alert apparently doesn't use...

And I seem to be confused as to whether or not these optional tasks are inside or outside the data flow. My suggestion applies to the Control Flow tasks.

Asita, could...

WordPress users, can you answer some questions for me? http://www.sqlservercentral.com/Forums/Topic1400585-61-1.aspx.

Do you know how to use Script Tasks? I use them to check the values of my variables after the variables have been set.

Here are instructions in case you...

Put the "optional" tasks in a sequence container. Then have the precedence constraint from task 15 (or whereever you're checking your conditional value) go to the sequence container using "Success...

EL Jerry (12/26/2012)

---

Thank you for your response, Greg.

Greg Edwards-268690 (12/26/2012)

---

If being run as a SQL Agent Job, you should be able to track down if it is in MSDB or...

Teal,

Thanks for the code. I can be pretty liberal when it comes to this sort of thing, so long as I can prove it won't kill the system. I...