I already have it set up to increment, I just need to grab the next record in the table following the one I update.

What type of an SSIS object do I put the code into? Sorry I don't have much experience with this yet.

Thanks

Used the replace with an update statement, thank you very much.

Great, thanks Holger

Is there anything special though to attach any of the database? I don't have to log on as a single user? I can just simply copy the data...

That article shows if you are moving the mdf and ldf, not restoring from a bak file correct? I am using a bak file to move all the data...