I understood that I have to do it with merge join / lookup and then conditional split, the problem is that I can't understand how to do it when I...

someone please...

Everything is correct, it seems like a bug...I thought that maybe someone have seen this problem before and has a solution.

Hi,

Do you want me to send you the query?

( the query works fine...)

if you don't run with full recovery you can do:

1. select into some temp table all the data you don't want to delete.

2. truncate your table.

3. select into your table...

http://technet.microsoft.com/en-us/library/microsoft.sqlserver.dts.tasks.executesqltask.executesqltask.bypassprepare.aspx