Post reply

Multiple Destination Tables

  • 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

  • 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

    .

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply