I would like to create a DTS package that will copy tables from one database
to the other daily.

This tables should be 120 days old {created more than 120 days ago and they
should have data}

After the tables are moved, I would like for the source tables to be
truncated.

Any suggestions on how to go about this ?

Hello John,

When you say copy tables I presume you mean the data within the tables.

If you can identify the date of the data within the tables then you can use
a Transform Data Task with a SourceSQLStatement set to your query that only
selects the relevant data. On Success iof the transfer of the data through
workflow you can TRUNCATE tthe source tables using an ExecuteSQL task.

Have I understaood your requirements correctly?




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com