SQL Server Performance

DTS Package

Discussion in 'General DBA Questions' started by avmreddy17, Jan 22, 2003.

  1. avmreddy17 New Member

    Hi,

    I have to Export a Table from SQL Server to Excel on a Daily Basis and I want to use DTS Package for that.

    I was able to create the pacakage but its appending the data , which I don't want .. I need to overwrite the data and how to Accomplish this??? Any help on this is greatly appreciated

    Thanks,
    Venu
  2. bradmcgehee New Member

    What you need to do is to recreate your package. When you do so, there is an option (easy to miss) that allows you to delete the old data and add the new, not appending the data as it is now.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  3. satya Moderator

    Under DTS wizard under transformation make sure you ticked drop old data.

    Satya SKJ
  4. avmreddy17 New Member

    Thanks Guys for all the help!!
  5. scrappy New Member

    quote:Originally posted by avmreddy17

    Hi,

    I have to Export a Table from SQL Server to Excel on a Daily Basis and I want to use DTS Package for that.

    I was able to create the pacakage but its appending the data , which I don't want .. I need to overwrite the data and how to Accomplish this??? Any help on this is greatly appreciated

    Thanks,
    Venu
  6. scrappy New Member

    Hello

    I saw your problem. I have a need to export to an excel spreadsheet on a daily basis as well. What did you do to create the package?

    Thanks

    KH
  7. Chappy New Member

    If youre not overly familiar with DTS Designer, you can create simple DTS's using import/export wizard (see start menu). This gives you the option to save the process as a DTS package.
    Its probably worth putting in the time to learn DTS designer though, although its not always very intuitive IMO.

Share This Page