Hi I have to transfer 12 tables from say databse 'a' and 10 tables from database 'b' using ssis package to database 'c' and i have to rename the all the table in database 'c' with '_bak' at the end of all table's.Table name are same i.e
databse 'a' have table's
1. transaction 2. suplyer etc and
databse 'b' have table
1. deliverd 2. status
then database 'c' already have those table from 'a' and 'b'
now they have to rename by _bak and copy againg those table from database 'a' and databse 'b' to database 'c'
View Complete Post