SSIS Transfer Object Task Error - Selecting Tables To Copy

I'm using a Business Intelligence project to copy stored procedures and tables from one database to another across servers. I'm having trouble copying tables or stored procedures using the Management.SMO.Transfer class.



I tried copying stored procedure with the property transfer.CopyAllStoredProcedures = true. This didn't work. As a workaround, I used the StringCollection property and executed every string as sql.



Now I'm having trouble copying tables. I don't want to copy all the tables in the database. How do I go about selecting what tables to copy. I tried using ObjectList property and provided the names of the tables in an ArrayList. I get the error

"Transfer cannot process System.String. You need to pass an instance class object."



How can I pass an "instance class object" for something that's in the database? The ScriptTransfer method fails so I can't even see the script that is being generated. There is virtually no documentation for this class.



Any help will be appreciated.



Transfer transfer = new Transfer();

transfer.Database = sourceDB;

transfer.DestinationDatabase = DestinationDatabase;

transfer.DestinationServer = DestinationServer;

transfer.DropDestinationObjectsFirst = false;

transfer.CopyData = true;

transfer.CopySchema = true;

transfer.CopyAllObjects = false;

transfer.CopyAllTables = false;

transfer.CopyAllStoredProcedures = false;

transfer.Options.WithDependencies = false;

GetTablesToBeCopied();

transfer.ObjectList = tablesList;



transfer.Options.FileName = "C:\TransferScriptTables.sql";



StringCollection coll = transfer.ScriptTransfer();