There isn't an out-of-the-box function for that, but this blog posts suggests an implementation:

http://sqlblog.com/blogs/adam_machanic/archive/2006/12/18/medians-row-numbers-and-performance.aspx

But it seems the next version of SQL Server, code named Denali, will have something that resembles...

Nice question, thanks.

Easy question, thanks.

Phil Parkin (9/21/2011)

---

Koen Verbeeck (9/14/2011)

---

Phil Parkin (9/14/2011)

---

I also read an article not too long ago, which I cannot now find (grr!), which suggested that SSIS was the wrong tool to...

Excellent question, thanks!

You can do it in SSIS by putting a Data Conversion component that converts the strings to int.

Map the error rows to a derived column that replaces the strings with...

Nice question, thanks!

Nice question, thanks.

Nice question, thanks.

CozyRoc (9/14/2011)

---

Koen Verbeeck (9/14/2011)

---

The only real limition is the size of the machine's memory (RAM) where the package is running on,...

sqlfriends (9/14/2011)

---

so do you agree what wildh says in his post:

Running in design time will result in using the connections from the connection manager rather than you file.

Running any package...

Allright, a picture says more than a thousand words. See the file in attachment.

It is a screenshot of the validation messages when I open a package. (apparently, in this case,...

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the scary,...

Phil Parkin (9/14/2011)

---

I also read an article not too long ago, which I cannot now find (grr!), which suggested that SSIS was the wrong tool to use in the case...

sqlfriends (9/14/2011)

---

When you open your package in visual studio, it will look for package configurations and configure your connection managers if the package configurations are found.

This means that design time...