Advertisement

09.14.2007 at 12:58PM PDT, ID: 22829935
[x]
Attachment Details

SQL DTS to Create new Excel file

Asked by jmantha709 in MS SQL DTS, MS SQL Server, SQL Query Syntax

Tags: dts, excel, file, sql, create

Hi Experts,
Currently using SQL Server 2000 but I could update to 2005 soon.

This is what I wan't to do from a SQL DTS:

1. Rename existing Excel file adding the date to the name (ex: File.xls becomes File2007-09-14.xls)
2. Create a NEW Excel file
3. Take data from Stored Proc and put it in the new Excel file

I know only basic stuff with DTS...  I would like suggestion on how to best achieve those task.

Thanks

PS I'm leaving work at this moment and won't be able to check back on this question until monday morning.
Have a nice weekend !
Start Free Trial
[+][-]09.14.2007 at 02:21PM PDT, ID: 19895232

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, MS SQL Server, SQL Query Syntax
Tags: dts, excel, file, sql, create
Sign Up Now!
Solution Provided By: dbbishop
Participating Experts: 1
Solution Grade: A
 
 
[+][-]09.17.2007 at 07:05AM PDT, ID: 19904984

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628