ankita.patel01 81294 (12/27/2011)

---

hello,

I need to write something in SSIS that will say if my percentages does not equal 100 % then add the total, and whatever the difference is +/-...

Capt. Sigerson (12/21/2011)

---

It's a good point about how to manage the volume of files in that folder. These are files that can be discarded after upload, but it's a problem...

I don't think that the solution proposed is necessarily the best one, as it depends heavily on you being able to derive the name of the file.

What I would do...

I particularly like this sentence:

presumably creating some sort of data vacuum which may implode the pipeline?

😀

Slightly unusual syntax. Try this

SELECT a.TransactionNumber ,

a.StoreID ,

a.Transaction_Date ,

...

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...