:blink:

That is some complex join logic you've got going there.

Let's get back to the original design flaw, a table that's getting dumped and rebuilt every few minutes. ...

No. You'll want to pretty much do this at the T-SQL level and feed it up.

Correct. All it does is get you ready for a separation down the road.

The only time you get performance gains between the multiple files is when they are on...

CirquedeSQLeil (3/17/2011)

---

Craig Farrell (3/17/2011)

---

CirquedeSQLeil (3/17/2011)

---

Brandie Tarvin (3/17/2011)

---

Craig Farrell (3/17/2011)

---

Annnnd, now I have an image of sheep storming the castle. I wonder if they fit their armor before or after...

CirquedeSQLeil (3/17/2011)

---

Brandie Tarvin (3/17/2011)

---

CRAIG!

Stop giving me...

Brandie Tarvin (3/17/2011)

---

CRAIG!

Stop giving me story...

Phil Parkin (3/17/2011)

---

OK, simpler version:

public void Main()

{

...

Ewwww... VB ftw!

In the books section on the left, you'll find a book by Grant Fritchey called SQL Server Execution Plans. An excellent walkthrough on most of the things you'll encounter...

You guys take all the fun out of a quick one-liner. 😛

And Tomm, no they're not qermso... somethingorothers... they're just dumb and excitable, so they get ahead of themselves. 🙂

Annnnd,...

CozyRoc (3/16/2011)

---

Guys,

I did the following:

- defined TaskName in ReadOnlyVariables input.

- called the following code from script: MsgBox(Dts.Variables("TaskName").Value)

And it worked, showing script task's name. I think it is incorrect to use...

Nevermind, I see the problem. You don't have evaluations in your strings, as Phil mentioned earlier. You need to test findstring to see if it found the character...

Then group on the unionall of userid alone, then use that as a subquery back to the different tables to return the records.

Jeff Moden (3/16/2011)

---

Ok... I'm pretty much ignorant of SSIS. My question at this point is why couldn't one of the common split functions written in T-SQL work here for...

Grant Fritchey (3/16/2011)

---

It looks like the Stream Aggregate is getting called in a loop. If you look at the actual output from it, it has 83 rows. The table spool...