Dev (12/21/2011)

---

Koen Verbeeck (12/21/2011)

---

Tsk tsk tsk, Hall Of Fame, is that the christmas spirit?...

Please take a look at one of your posts and, if you decide that you are happy being referred to as 'Valued...

apatel 80451 (12/20/2011)

---

Hi Phil,

Im successfully getting the YTD figure for the current year, but how can i compare this figure to data for the for the equivalent month the year...

Greg J (12/20/2011)

---

fast-load... never saw it have such a dramatic effect.

SORT in SSIS... yeah, learned that pretty quickly. I've ORDERED BY at the source to overcome this.

Lookup/FullCache... didn't know...

Come on Mark, tell us about the special character 🙂

christian 92959 (12/20/2011)

---

Hi Phil,

thank you for the imediate response, i changed my query to your advise ... but its not faster at all.

Investigating the execution plan gives me the information...

Thanks for the feedback and no problem.

Note: use

datediff(dd,0,getdate()) - 7

If you'd like to remove the time component from today - 7

christian 92959 (12/20/2011)

---

Hi there,

first of all thank you all for the tips and hints here, ive got alot of tips out here for my daily work ! Thanks !

Now my...

Paul_Harvey (12/20/2011)

---

Hello all,

I have a question, which hopefully won't require too much time from the person that knows the answer!

I have a very simple SSIS package, which performs a few...

Please post the error message, if there is one.

Add a derived column in your dataflow and set it to the value of the variable containing the file name.

Then map the new column to your database column as usual.

Wow.

Even the requirement of knowing whether or not the moon is gibbous is catered for 🙂

No problem, thanks for posting back.

I see. OK - I put an ASCII 30 character into a Word document, then copied that to the clipboard, then pasted it into BIDS.