Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: DTS Package - Delete Rows from a DB4 File

    I have to run a DTS package to export data into a dBase file. I first have to delete the existing data within the dbase file, but I can only get it to delete the data, not the actual rows. The file continues to grow in size. Is there a way to delete the rows from the dbase file through the DTS package?

    This would help out a lot, thank you!!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Why don't you just delete the file, then recreate it?

  3. #3
    Join Date
    Jan 2004
    Posts
    6
    There were reasons for not deleting the file. I figured it out and should have a long time ago. I run an automated Pack/Rebuild which premanently gets rid of the rows marked for deletion.

    Thanks for the help.

    Originally posted by rdjabarov
    Why don't you just delete the file, then recreate it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •