Multiple Destination Tables

• gansindia

  SSC Rookie

  Points: 44

  More actions

  August 15, 2002 at 1:33 am

  #105130

  Hi,

  Any input of how to move data from one source table to multiple destination tables

  Any help in this regard greatly apprecaited

  thanks

  gans

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  August 15, 2002 at 5:38 am

  #434611

  Are the source and destination tables both SQL Server tables? If so, then just use TSQL commands to move the data. If your source is a flat file or spreadsheet for example then use DTS to load the data into one holding table and then run TSQL commands (call a stored procedure within your DTS package after laoding the data) to move the data into the destination tables.

  Regards,

  Andy Jones

  .