ChrisM@Work (9/11/2013)

---

Hany Helmy (9/11/2013)

---

I am really amazed of the 16 people (as of now) who got it right! :w00t:

Hope one of them will post a reply explaining how he got...

Jeff Moden (9/10/2013)

---

Koen Verbeeck (9/10/2013)

---

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are...

jasona.work (9/10/2013)

---

Koen Verbeeck (9/10/2013)

---

Grant Fritchey (9/10/2013)

---

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos...

Did you enable logging in the SSIS package? If yes, is there something useful in there?

The deployment models are they way SSIS packages are developed in SSIS 2012.

You have two models:

* the package deployment model: the unit of deployment is a single package. This is...

Maybe a little more information is needed?

What are you using as a data source?

How did you create the tablix?

Any expressions/filters on the tablix?

alekya.kondam (9/10/2013)

---

HI ,

select * INTO Test FROM

(

select ROW_NUMBER()over(partition by customer order by customer) as counts ,customer,Contract

from tablename

) A where ...

Grant Fritchey (9/10/2013)

---

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our...

paul.knibbs (9/10/2013)

---

Doesn't it mean the thread goes to school soon and we have to tearfully wave it away...

ntuschiev (9/10/2013)

---

Thanks for your reply,

this sounds as the most natural way, but I don't want to change my job at this moment, so this is not an option for...

I found a company that was willing to invest in me.

They hired me as a junior BI developer and they put me on a project with some senior DWH developers...

HanShi (9/10/2013)

---

If there are double rows (like the same NAME is entered twice both with the ROLE 'User') the solution of Koen will give false results. The code below will...

You should throw your server into the Hadron collidor to have it examined. 🙂

This should do the trick:

SELECT Name

FROM SAMPLE

GROUP BY Name

HAVING COUNT(*) > 1;

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread......