I am using DTSWizard Export in our SQL Server Standard 2005 to export data
from six tables to another SQL Server Express 2005 outside our network.

I can run the Export for one table at a time and it works great. If I run
the Export for multiple tables it will duplicate all the records in the
destination tables.

I Select the Export Data Task and the correct source and destination. I now
select the Copy data from one or more tables or views. Next I select the six
tables that I need and then select Edit Mappings. The Destination schema
name is dbo and I select the Delete rows in existing destination tables.


Thank you
Frank

I found the problem, I had to select each table one by one when setting the
Delete Rows from the Edit Mappings. This is now working well as an SSIS
package running in scheduled jobs.

"Frank" wrote: