Transfer SQL Server Objects Between Databases
Wires a TransferSqlServerObjects task to a SqlServerManagementConnection so a package can copy a hand-picked list of tables (and their data) between two SQL Server databases, dropping the destination objects first when they already exist.