SQL Server Performance

replace old files when import

Discussion in 'SQL Server DTS-Related Questions' started by yanke_zulu, Dec 30, 2003.

  1. yanke_zulu New Member

    hi I am new to sql server
    I have about 150 .txt files everyday. I schedule DTS to import these files everyday.
    but I want it to replace old files. because each day it append new records to new table.
    is there any way to delete old file

    Another issue is when I try to schedule it ask to start sqlserveragent.
    I made it automatic. But when it starts a windows pop up that shows sqlserveragent started in dos command menu. any idea

    thanks in advance

  2. Twan New Member

    How have you created the DTS package? If through EM then there is an option in the GUI to replace data rather than append.

    Where are you trying to schedule the task from? and how? what command line are you trying to run?

    Cheers
    Twan
  3. satya Moderator

    You can do with activex script and for code examples may search underhttp://www.sqldts.com.

    For the second issue under Control panel --> Services for MSSQLAgent remove tick mark for 'Allow service to Interact with desktop' and it will solve the problem of opening dos window.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. yanke_zulu New Member

    I am trying in EM
    in any database from menu all task->import
    I havent seen any option in GUI like append or replace
    Could you please tell me which menu should I use

    thanks in advance
  5. Twan New Member

    The place where you specify the destination table should have a button next to it marked ... This is the transformation button, this takes you to a screen when you can set the task to drop/create the table, delete all data from the table or append

    Cheers
    Twan

Share This Page