Result set in DTS

• sree-226516

  SSCrazy

  Points: 2590

  More actions

  October 13, 2005 at 9:54 am

  #166462

  Hi,

  I have a question inDTS.we have two servers A and B.Using DTS I am going to execute store proc in Server A and I want to move  only result set into table in Server B.I appreciate if anybody can tell me how Can I move the result set of stored proc from one server to another.

  Thanks,

  Sree

   

  Thanks,
  SR

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 13, 2005 at 10:21 am

  #597151

  when you are creating your package on your pump task it asks you for a table/view or a query. In the query window type in your stored procedure name.

  Dts will interrogate the proc for fields, and they will show up so you can use in the destination, and transformation tabs. Have you tried this?