Home Forums Programming SMO/RMO/DMO SSIS Vs Linked Server with SQL Agent Jobs RE: SSIS Vs Linked Server with SQL Agent Jobs

  • Good Question. This is required as there will be changes made to the columns at Source (adding or dropping columns). If we go with SSIS, we need to do mapping too.

    Please advice that SSIS is the better choice.