dfine (7/5/2013)
[font="Arial"]Yes, this is one time exercise. I planned to go with SSIS package because as per the company policy I should not use linked server approach. There are 129 tables but I am only interested in 70 tables.[/font]
Just use the import/export wizard, this will be the fastest.
When the SSIS package is created for you, remove all precedence constraints to force the package to run in parallel.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP