DTS Job to archive data every 2 weeks

Last Post 29 Oct 2008 01:04 PM by phsatech. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
phsatech
New Member
New Member

--
26 Oct 2008 05: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 01:04 PM
great thnxs did the trick.


Acceptable Use Policy
---