I want to copy a table out to an Excel file at the end of every month. The
Excel filename needs to be unique each month like:

Dec03.xls
Jan04.xls

and so on....

any easy way to do this with a Pump Task ?

I personally would have

an ExecuteSQL task that does a CREATE TABLE statement against the Excel
Connection. You then set the DestinationObjectName to be the name of the
new "Table" in the spreadsheet. You build up the SQL Statement and the
assignment of the Destination using a variation on this article

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"HartA" <Hoosbruin (AT) Kconline (DOT) com> wrote