Hello

I have would like to find out the best scenario for this package. I have 2 identical Databases Test1 and Test2 in Test1 I have 2 tables Customers and Addresses. I would like to export data from Test1 the 2 tables into Test2 database same tables. After the data is exported I would like to remove it from those 2 tables in Test1 database. Hope this is not too confusing. Thanks for all help

You could do this

Task 1: ExecuteSQL task - Deletes from the 2 destination tables
Task 2(*2): DataPump task - Pumps the data from Source to destination
Task 3: ExecuteSQL task - Deletes from the 2 source tables




--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


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

Addresses. I would like to export data from Test1 the 2 tables into Test2
database same tables. After the data is exported I would like to remove it
from those 2 tables in Test1 database. Hope this is not too confusing.
Thanks for all help!