Hello Mary,

You can have a package that looks like this (please forgive my ASCII art):

Execute SQL Task ----- On Success ---> Connection 1 ----Data Pump
Task----->Connection 2

The Execute SQL Task will perform the insert into Authors1. The Data Pump
task will transfer the data from Authors1 to Authors 2.

Hope this helps,
Farooq Mahmud
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no
rights.