Discussion in 'SQL Server DTS-Related Questions' started by Anusha, May 4, 2008.
You can add a sql task in the package to perform conditional purging of data.
you can store the datetime of last purge in a table and when the time difference is 4 hours with current time,
you can initiate new purge with updating the datetime column.
Do not post your complete question in the subject, explain further on your case within the reply seciton.
Separate names with a comma.