SQL Server Performance

I scheduled a package in enterprise manager.The package performs data transfer task for every 4 hours from a CSV file to SQL 2005 database.But the dat

Discussion in 'SQL Server DTS-Related Questions' started by Anusha, May 4, 2008.

  1. Anusha New Member

  2. ranjitjain New Member

    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.
  3. satya Moderator

    Do not post your complete question in the subject, explain further on your case within the reply seciton.

Share This Page