Using Global Variable script

• man-219957

  Newbie

  Points: 7

  More actions

  September 12, 2005 at 1:55 pm

  #66695

  I want to transfter data from one table on server 1 based on paramter

  and insert the result  into a table on server 2 (both sql server)

   

  any idea how to do this using global variables in DTS?

   

  Thanks a Lot

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  September 12, 2005 at 2:42 pm

  #589176

  Check out

  http://www.sqldts.com/default.aspx?205

  sqldts.com has a ton of articles about this stuff.

  copying between servers is easy, you can set up connections for each server, and create data pump tasks.

  Take a look, Read a book.

  The Reading Rainbow