SQL Server Performance

Query results to New Excel File Everytime in DTS

Discussion in 'SQL Server DTS-Related Questions' started by EasySQL, Apr 4, 2006.

  1. EasySQL New Member

    When I run my DTS through a job on a daily basis i want to save the query results
    to a new .csv file or excel file.The files can be named as daily dates.
    Do i have to use any activex script to achive this.
    I want the file to be renamed on the fly and data saved in it.
    Thanks in advance.
  2. Luis Martin Moderator

    The only way (I know) is to rename the file after DTS was done. Could be with Windows Scheduled Task.
    But wait for others members oppinions.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. Luis Martin Moderator

    "I want the file to be renamed on the fly and data saved in it."

    Just to clarify, that was written after my post.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  4. Madhivanan Moderator

    See if you find such code here
    www.sqldts.com

    Madhivanan

    Failing to plan is Planning to fail
  5. Adriaan New Member

    There are some switches that you can use on paths, like %USERNAME%, that are resolved at runtime. You'll have to test - it doesn't always get evaluated.
  6. EasySQL New Member

    Hi Luis
    yes i updated the message for a clear requirement.
    Thanks for all the replies
    Love this forum

Share This Page