SQLTeam.com | Weblogs | Forums

SSIS Transfer data from one sql server to another sql server(Server to local)

Hi All,

      My table size is 80GB. In that table one column is XML when i transfer the table from server to local using SSIS like OLED Source and OLED Destination it will take time more almost 15 hours time take .How to reduce the time like fast way to transfer the data using SSIS.Please check below column list.

id name xmldata

Please help me

Regards

Pols

I don't know if you have a key in the table but you can speed up by making 4 tasks and each load 25% of the table.

This is a nice article to give you more details.
Top 10 Methods to Improve ETL Performance Using SSIS | Developer.com