SQL to Excel -- sql server dts

Shailesh
7/21/2003 10:58:50 AM

Hi all,

Using the DTS services I can schedule a report in Excel of
my data in SQL 2000 at the start of every month. There are
a few requirements that I have to meet. At the end of
every month I want an excel repot done for ONLY that
month. So on the 1st of September, I would want a report
from 1st of August to the 31st of August. Plus on the top
of each report I want the information about from what
dates the report is eg Start date = 1st of August; End
date = 31st of August. Is there some way this procedure
can be automated and if so how?

Thank you.

JFB
7/21/2003 4:33:01 PM

Hi,
Yes it is a way...
Schedule the DTS pkg for the first day of the month and using activeX script
you can set couple global variables one with the start date and the other
variable with the end date base on month before the month is running using
the system date.
JFB

[quoted text, click to view]

sql server dts : SQL to Excel