SQL Server Performance Forum – Threads Archive
Query results to New Excel File Everytime in DTS
When I run my DTS through a job on a daily basis i want to save the query resultsto 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.
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.
"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.
See if you find such code here
www.sqldts.com Madhivanan Failing to plan is Planning to fail
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.
Hi Luis
yes i updated the message for a clear requirement.
Thanks for all the replies
Love this forum
]]>