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

    Anusha, May 4, 2008
    #2

  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.
    ranjitjain, May 5, 2008
    #3

  3. satya Moderator

    Do not post your complete question in the subject, explain further on your case within the reply seciton.
    satya, May 6, 2008
    #4

Share This Page