I would like to add to a DTS package I created a task
that copies a specific Access database to another
location and adds the current date to the name. For
example, we might have a client.mdb in a client folder
and each time the DTS package runs we want to copy the
current client.mdb to a clientcopy folder with a name of
client111403.mdb.

Is this possible to do in DTS? And if so, which task
would I use? Would I need to create another connection?
I currently have one for the client.mdb database and one
for my SQL Server database where the update data comes
from.

The reason I want to do this in DTS is client.mdb is
updated daily from a SQL Server database and, for a
little while, I want to make a copy of the current
client.mdb before the update occurs.

Thanks for your help.

Then you could use the ExecuteProcess task and the COPY or RENAME commands
in DOS

--

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


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