sql server - SMO Transfer Class to transfer table with none default schema -

sql server - SMO Transfer Class to transfer table with none default schema -

in ssis using code blog .. blog utilize smo transfer class

i want transfer 2 tables, each different schema ..

dbo.table1

ctl.table2

the table dbo.table1 gets transferred.

i error ctl.table2.

the error value cannot null.

i checked transfer.options properties not finding help.

also tried setting transfer.copyallschemas = true not help either.

thanks in advance,

found method in transfer class utilize transfer object ctl schema instead of dbo.

for specific schema need utilize ..

xfr.objectlist.add(db.tables("table2", "ctl"))

this transfer `ctl.table2.

sql-server ssis sql-server-2012 smo