Copy 300 tables from One SQL Server to another SQL Server.


  • I have a requirement to copy 300 + tables from various DIFFERENT SQL Servers to One Destination SQL Server B.

    These tables have diff structures . I wanted to use SSIS packages to do this, using a DATA FLOW TASK AND FOR EACH LOOP To loop thru all tables and copy data over. However Data Flow task is not dynamic hence cannot use.

    So I cannot do DFD Task since structures are NOT same on these 300 tables. ANy suggestion for the best approach to do this?

    • Moved by Kalman Toth Friday, February 21, 2014 9:29 AM Better fit
    Thursday, February 20, 2014 10:39 PM

All replies