move data to another server temp table

• niranjankumar_k

  Ten Centuries

  Points: 1075

  More actions

  May 23, 2008 at 4:07 am

  #71959

  i have 2 servers ( A,B) i pull the data from B to A .. without linked server need to pull and and insert in to teamp table of A server.

  instead of linked server we can use open data source .. but not sure about this ...

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  May 24, 2008 at 3:23 am

  #819979

  If you are working with SQLServer 2005, then you can make use of SSIS packages. Create a SSIS package to do the same!

  Regards..Vidhya Sagar
  SQL-Articles