sqldriver (2/18/2014)

---

I appreciate that SSIS is a good tool for this situation, but I'm in kind of a weird environment where it's not accessible, on top of me not liking...

It's due to the logic break.

You get the last date from the table for @Month, and then compare that to the month for GETDATE() (which, btw, will be REALLY screwy...

99% of the time this is a syntax error.

I don't use C#, I use VB.NET, but DTS.Variables("VariableName").value.ToString() is usually how it's written, not with [].

sqldriver (2/15/2014)

---

I really hate SSIS and was hoping to avoid it. I guess I could try doing this all in another language that handles large file operations better. Of course,...

Start on the target, and find the spid for the SSIS component running. Try to determine most common wait type. If it's PageLatchIO or another variant on disk...

Grant,

that's a very interesting result you found there, but I guess I should have restated my question. The order does matter, but not for the reasons you checked. ...

I'm going to fire a bombshell that will probably get me shot, but here it is:

I rarely use FKs.

Not because I trust the application, I don't. I could throw...

Jack Corbett (2/13/2014)

---

Now onto the reason I had time to catch-up today. I was informed that due to financial problems at my now former employer, my position...

If you take a look at the second link in my sig (index/tuning help) you'll see some pieces we need to help you. Even though you can't get an...

Gillian_Pappas2002 (2/13/2014)

---

I am just trying to update a customer order field with a max invoice date from the invoice header. I didn't know you could use a sum on...

Grant,

My understanding was the short circuit capabilities of the CASE statement would improve performance, but in a limited variety.

Instead of a simple data change on the table with no where...

There's not enough there to actually write you a statement, but I'll give you the layout:

UPDATE co

SET fielda = sumFieldb

FROM

Table1 AS co

JOIN

(SELECT

keyfield,

SUM(something) AS sumFieldb

FROM

tabl2

GROUP BY

keyfield

) AS...

Grumble mutter... mistypes... grumbles..... Hush you! ...

Glad you got it working. Yes, datatypes can be frustrating sometimes in SSIS but honestly, you'll get used to them (and the errors, due to seeing them a few...

CI in databases is a thorn in my side, and has been for a long time. The reason for this is the intricacies the code needs to have to...