Multiple Destination Table in DTS

Question

Multiple Destination Table in DTS

gansindia

SSC Rookie

Points: 44
More actions
August 14, 2002 at 1:28 pm

#105129

Hi ,
I would like to one Source Table to multiple destination table using DTS , how can i achieve
For Example:
My Source is Foxpro and my Destination is SQl Server 2000.
I have table called Customer Table in Foxpro
but the SQl Server has got CustomerTbl,CustAddTbl . Now i want to map the columns in Source table to two destinations table(assuming column from source can be mapped to corresponding columns in destination tables ..
Thanks in Advance
gans

Viewing 5 posts - 1 through 4 (of 4 total)

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

bmsjr Ten Centuries Points: 1199 More actions · Answer 1

You could create a temporary table in SQL and then move the data from foxpro to this temporary table. I would then do a two step transformation and move the required fields from one table to each of the other tables. I have not tried it but you may be able to create a view between the tables and update the view.

Bruce Szabo, MCSE+I, MCDBA, MCSD

cwedgwood50 SSCommitted Points: 1751 More actions · Answer 2

Is there a reason why you can't just Create 2 DTS packages? One for each destination table.

gansindia SSC Rookie Points: 44 More actions · Answer 3

thanks i have done it by moving to temp table and then using stored procedure in the destination side to move data from one table to another.

thanks for the input.

gans

scotttr SSC Eights! Points: 965 More actions · Answer 4

In DTS you can create multiple destinations and connect them to a single source using an individual transform for each destination. Just create the destinations, then hold down the ctrl key and select the source then the destination and then hit the add transform icon. You can run them concurrently or in parallel.