xRafo (12/29/2011)

---

I just Need 1 row.

The table have around 2000 records.

I've been testing the above query but sometimes give 2 times return the same value,

I need not repeat random...

CHANDRASHEKHAR SINGH (12/29/2011)

---

Hi,

Building a package is a standard Practice. When you deploye your package from Dev environment to Production environement, you should build your package, which will craete the .msi...

How does this help in determining whether the...

Not all millisecond values can be stored by a SQL Server datetime column and perhaps this is causing issues?

For example

select CAST('2011-12-21 14:29:54:304' as datetime)

will return 2011-12-21 14:29:54.303 - showing that...

ankita.patel01 81294 (12/27/2011)

---

that is how we're receiving the data as text. and, need to use ssis to convert this data to proper data type and transform with these scenarios to...

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 🙂