LAMOROTF, can't wait to see that on youtube :D.

I'm a bit curious here (never used SSIS). So you are saying that this sort transform basically only keeps 1 row PER manager. Can you decide which row...

Doesn't that make 24 e-mails a day anyways? :w00t:

This of course assumes that you are using sql 2005.

Sorry to go this basic... but if you made a tiny posting error and are using sql 2000, you...

That sounds about right (I'm just no expert there), but sleeping seems like "done doing my batch" to me.

I see what you are going through. But on the other...

Thanks, but I meant the query you are using ;).

Create a table (like any other table). Make sure the name is significant like Staging_Managers.

The insert all the data in that table. (Make sure you truncate before the...

It's basically the same answer as I want to restore without a backup... you're screwed my friends. Learn and move on.

Now would be a good time to learn to...

Please post the actual code, it's eaiser for us to help that way.

What login are you using?

Does that login have permissions on all DBs?

Well step 1 in any etl is EXTRACT.

So I'd put all that data into temp table then I'd start the transform tasks. Then my query would easily work.

Back to the basics... why is this causing you a problem? Are you having blocking issues, running out of ram?

If you just have many sleeping connections and no other...

This is a hack but it will do the job : run subcription with default name.

Create a windows task that renames the file with for exemple today's date (might have...

What did you try and what is wrong with those results?

How do you define the first guy??

SELECT * FROM Source INNER JOIN (

SELECT Manager_id, MIN(emp_id) FROM Source GROUP BY Manager_ID

) dtFirst ON Source.Manager_id = dtFirst.Manager_id and Source.emp_id = dtFirst.emp_id

inner join...