transfer multiple tables data

• shuzi

  Say Hey Kid

  Points: 684

  More actions

  April 29, 2008 at 10:10 am

  #76966

  Hi, we are using sql 2000, i would like to know is there a way to transfer multiple tables data (export and import) from one server to another server by using one DTS? thanks.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  April 29, 2008 at 10:28 am

  #808538

  Sure. You just have to use a Transfer Data task for each table.

  Greg