DTS Job to archive data every 2 weeks

Last Post 29 Oct 2008 12:04 PM by phsatech. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
phsatech
New Member
New Member

--
26 Oct 2008 04:16 PM
I have a simple DTS package that will do a once time archive of 2 large transaction tables to archive database based on a date column i.e SELECT * FROM TABLE WHERE RUNTTM is =< 'date' (2 steps, move data to archive and delete source)

How could I regularily run this say every 2 weeks( after main batch has run above) , where SQL Server will pick up the last 2 weeks of data? using existing DTS package?

appreciate insight
phsatech
New Member
New Member

--
29 Oct 2008 12:04 PM
great thnxs did the trick.
You are not authorized to post a reply.

Acceptable Use Policy