The Transfer Database Task would move or copy the entire database files from source to destination. I found the Transfer SQL Server Objects task to be more convenient. We can...

Thanks, but I am looking to make it dynamic. I already created an SSIS that does the transformation, but I had to created 20 data flow tasks for each table....