InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:34:30 GMT20http://www.sqlservercentral.com/Forums/Topic1393624-392-1.aspxSSIS lookup is working well.Tue, 11 Dec 2012 11:02:16 GMTErin.http://www.sqlservercentral.com/Forums/Topic1393624-392-1.aspxReplication could be problematic as SQL will replicate the DELETEs as well as the INSERTs.Also, do you need to capture UPDATE activity or just INSERTs?Finally, are you on Enterprise or Standard Edition?CDC could work well for this if you are on Ent Ed (unfortunately, CDC is not available on Std Ed).Mon, 10 Dec 2012 16:17:23 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1393624-392-1.aspx[quote][b]Erin-489205 (12/6/2012)[/b][hr]Development has created 7 day rolling tables on multiple servers. I want to pull this data over to another table so I can trend daily averages over a few months. The rolling table is populated throughout the day meaning data is added/removed every few minutes. What would be the best method to copy this data to my table without missing or creating duplicate rows?[/quote]Step 1 would be to find out how they are deleting the data so you can intercept it.Fri, 07 Dec 2012 19:37:25 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1393624-392-1.aspxDebating on using replication or SSIS Lookup.Fri, 07 Dec 2012 18:50:07 GMTErin.http://www.sqlservercentral.com/Forums/Topic1393624-392-1.aspxDevelopment has created 7 day rolling tables on multiple servers. I want to pull this data over to another table so I can trend daily averages over a few months. The rolling table is populated throughout the day meaning data is added/removed every few minutes. What would be the best method to copy this data to my table without missing or creating duplicate rows?Thu, 06 Dec 2012 09:52:14 GMTErin.