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