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
    avmreddy17, Jan 22, 2003
    #2

  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
    bradmcgehee, Jan 22, 2003
    #2

  3. satya Moderator

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

    Satya SKJ
    satya, Jan 23, 2003
    #2

  4. avmreddy17 New Member

    Thanks Guys for all the help!!
    avmreddy17, Jan 23, 2003
    #2

  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
    scrappy, Jan 31, 2003
    #2

  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
    scrappy, Jan 31, 2003
    #2

  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.
    Chappy, Jan 31, 2003
    #2

Share This Page