Transfering a couple of tables at a time
I missed some of the comments to my post about creating your own Transfer SQL Objects Task with a script task, so I thought I'd post the answer here incase people miss my answer.
You can use the ObjectList property of the Transfer object to specify which database objects you want to transfer. To transfer only certain tables from a database, you'd set CopyAllTables to false, and then add Table objects to the object list.
Note, when accessing the Tables collection of the Database object, you can specify the table by index or by name. You can also use an additional schema name parameter if there are duplicate table names in separate schemas.
Database sourceDB = new Database("source");
Transfer xfer = new Transfer(sourceDB);
xfer.CopyAllTables = false;
[...]
xfer.ObjectList.Add( sourceDB.Tables["table1"] );
xfer.ObjectList.Add( sourceDB.Tables["table2", "schema1"] );
xfer.ObjectList.Add( sourceDB.Tables["table2", "schema2"] );
xfer.ObjectList.Add( sourceDB.Tables["table3"] );
