SQL Server 2008R2 - I attached some records. What I will do is easy. In the column

attempt is for record #1 the value 1. If the next record #2 is...

I used a SQL statement on the table. I have not a lot of experiance with SQL Server 2008R2 but with DTS on SQL Server 2000. Here it was easy...

First: thanks for your feedback. Description may be strange while I am german.

I did some screenshots (attached) - for this dummy - maybe this will explain more. I run

this package...