Thanks brain for the article! It was really interesting. I managed to solve my problem eventually. A space was carried along with the number by a misstyped "case" of mine.

They are two 12 digit numbers as the rest of the results.

I just did a select on the original table for these specific rows and the return result is that...

Gladly! 🙂

What I did was create a temporary table to hold the grouped data and then selected those with the id = 1. If it was a default status it...

It did work after some changes so thank you all for your help!

Thank you Chris! That really helped me a lot! Think I am getting close now.:-D

Exactly the same problem I had with "count" too. Group By(and lack of experience :P) in general is killing me.

As default I want it to get the value that...

Brandie Tarvin (3/16/2011)

---

You can also put a CASE statement in your ON clause, forcing the code to make up a number or default to a value that will keep the...

Thank you Sean! I will look into it.

Well the desired output would be a table C with the following rows

C

Deal Number - Deal Status - Step Number

125 | Pro | 1

125 | Beg | 2

125 | Opn...

It finaly worked by changing move to copy and delete! Can't believe that it was something like that!

Thanks Dave!

Thanks for the suggestion Dave, I ll give it a try. I am not exactly an expert also so that's why I am struglling now 🙂

Plus regarding my second post the error message that I get is expected since I tried to run the package localy from my machine and not from the server directly....

Hi Dave and thanks for the quick reply!

My script goes like that

For Each oFile In oFiles

...

I have an update on my problem. I discovered that the problem was not with the job itself but with the package. I tried to run it through Integration services...