Got me there. I have barely just enough experience with SSIS to spell it. I was hoping it would give you some inspiration, but apparently not.

I'll leave this...

Is there still someone who doesn't know that it's pointless to update a row without doing any change (like in your exemple)??

That should be thaught in DB 101.1!

Just one question on that Jeff. How do you track the information of When, what, who inserted the original row?

I know this data should be kept separate from the...

Do you guys realize that there are more members than there are posts on this site?? There must be a massive amount of traffic comming from the search engines.

They'll be at least at 750'000 by then (assuming 12 months between summits).

Maybe even 1M if this site grows like it should... are you guys ready for the wikipedia??

I see. I think the DDL trigger can still do the job here (didn't check bol to be sure). I think it's your safest bet at this point.

Go into books online and learn how to do that. You must list all the columns you want to transfer in the insert clause and into the select clause....

This will still work... unless I missed something obvious :

BEGIN TRAN

Insert into WaitList (Columns) Select Columns FROM Candidates WHERE ID IN (2,4,5)

DELETE FROM dbo.Candidates WHERE ID IN (2,4,5)

COMMIT TRAN

Wow, that's the clearest explaination I ever saw for that question. Thanks Sergiy.

Let's start over.

Show us sample data from all three tables before the transfer.

Then show us what data needs to move and what information you have available at the moment of...

Nobody could have, thanks for pointing this out.

Testing GTM-5...

This works for me.

I don't get what is the problem in this context. The code should look a lot like this :

BEGIN TRAN

Insert into WaitList (Columns) Select Columns FROM Candidates WHERE...

Hey Steve, that would definitly make a good article. Maybe you could even make a contest out of it (like the nightmare contest). I'm sure we'd get a...

That's what I see.