Megha P (4/10/2014)
We are going to transfer data from denormalize db to normalized db.Currently both source and destination are on same server..but once i complete creating packages for all tables , we will make destination to production server.
Thanks,
Megha
Check if you can replace the MERGE JOINS with lookups.
If you are planning to transfer large data volumes, this package will kill your server.
(OK, a bit over dramatic, but it will use a lot of memory and it will be really slow)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP