I am new to DTS packages and not familiar with the object
model. I want to simply pull the results of a query on
one Server to another and save the results in a table
based on the date.

I have figured out a way to name a table I created based
on a text and date combination (i.e. BR200407) using DTS
Dynamic Properties and global variables, but it just
doesn't seem clean. Like I said, it works, just feels
like there is a better way. I would greatly appreciate
any suggestions. Thanks.

If the results of the Query have the same metadata and all you want to do is
change the name of the table each time then I personally would

1. Use an Active Script task to define the table that will be executed from
the SQLStatement property of the ExecuteSQL task You can build the table
name dynamically in this script.
2. Set that table as the destination(DestinationObjectName)

Have a look here

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)



--

----------------------------

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


"Jeremy" <anonymous (AT) discussions (DOT) microsoft.com> wrote